Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf Problem...trying to sum multiple columns | Excel Worksheet Functions | |||
Sumif Multiple Columns | Excel Worksheet Functions | |||
SUMIF and multiple columns | Excel Discussion (Misc queries) | |||
SUMIF over multiple columns | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions |