Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have checked and can't find anyone nesting sumif's by date and other
criteria. I have 5 columns that list (Production) a piece of equipment (multiples), the date(more multiples) for the same piece of equipment and then the quantity the equipment did. There could be 12 times the equipment is mentioned for a single day. I need to sum the quantity the piece of equipment did by the date. I have tried sumif(Production!A:A(date)=Summary!B1(specific date),sumif(Production!B:B=Summary!c1(equipment code),Production!C:C(quantity))) doesn't seem to like the nested if's. What else can I do? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
Sumif? | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |