We buy alot of Pipe,Fitting and Valves.
Besides Mcj-Redman, try Ferguson.
and for alloys Robert-James.
I suggest going to Thomas Register
Register and log-on is free
Good search of everything for Industrial,
and State specific
re: SUMIF with multiple conditions;
Column A has names (A2:A200)
Column B has dates (B2:B200)
Column C has corresponding values
In cell A210 I type in a name
In cell B210 I type in a date
In cell C210 I type in;
=SUMIF(A2:A200,A210&B210,C2:C200)
Oddly enough it works !
Say I have cubic ft in...