Sumif data from multiple columns
I don't quite understand what you are trying to do - can you re-
phrase?
Pete
On May 6, 3:18*am, Nick wrote:
I need to do *this:
A * * * * * * * * * * * * B * * * * * * * * * * * * * *D * * * * * * * * * *
* * F * * * * * * * * * *H
32 * * * * * * * * * * * 3 * * * * * * * * * * * * * * *2 * * * * * * * * * *
* * * 3 * * * * * * * * * * *4
44 * * * * * * * * * * * *3 * * * * * * * * * * * * * * 3 * * * * * * * * * *
* * * 2 * * * * * * * * * * * 3
Column A is a Length of material, Coulmns b, c, d, etc are how many pieces
apply to that length for a given type of material. There is an additional
material that holds three bars. So I need to know how many bars total I would
need based on this.
Example that doesn't work:
=SUMIF(F5:F23,H5:H23,J5:J23,L5:L23,N5:N23,P5:P23," =3",C5:C23)
Not thinking too hard, just hope someone has an answer
|