Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif with multiple conditions
We need to sum data in a spreadsheet where multiple conditions apply.
C2:C400 is quantity data J2:J400 is received date K2:K400 is due date. We want to sum the data in column c if the received date for a given record is in a given month (which will change every report cycle), and the due date for a given record is in any month following the received date month. I can write a separate formula for each condition but that doesn't necessarily help. When I try to structure a sumif using multiple conditions, I just end up with errors. Any help in understanding how to do it will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Sumif conditions | Excel Discussion (Misc queries) | |||
Multiple Sumif conditions | Excel Worksheet Functions | |||
sumif with multiple conditions | Excel Worksheet Functions | |||
SumIF-multiple conditions/OR | New Users to Excel | |||
sumif - multiple conditions | Excel Worksheet Functions |