Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum for multiple criteria
I have a situation with an input sheet where they put in a division name,
product name, month put in service, and quantity put in service in that month. The names are picked from validated lists, the month can be 1-60 for a five year span, and the quantity can be negative or positive. On another sheet, I want to create a sheet for each division that has a list of products down the left, the months across the top and in the cells, the sum of the entries that match the division, product and month criteria, which represent the number added or removed for that month. I tried sumproduct but it only allows two criteria and I have three here. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum for multiple criteria
Ignore this, I had an error in the sumproduct and when fixed it works fine.
"bobb" wrote: I have a situation with an input sheet where they put in a division name, product name, month put in service, and quantity put in service in that month. The names are picked from validated lists, the month can be 1-60 for a five year span, and the quantity can be negative or positive. On another sheet, I want to create a sheet for each division that has a list of products down the left, the months across the top and in the cells, the sum of the entries that match the division, product and month criteria, which represent the number added or removed for that month. I tried sumproduct but it only allows two criteria and I have three here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
Multple criteria dilemma | Excel Worksheet Functions | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |