Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use the sumif if I have multiple criteria (i.e. greater .
I want to use the sumif function to add up all expenses that occur between
two dates (Say, during the month of September, so between 09/01/2004 and 09/30/2004). I can't figure out how do use sumif with two arguement (sumif criteria is THIS AND THIS)? |
#2
|
|||
|
|||
"Kellyatisl" wrote in message
... I want to use the sumif function to add up all expenses that occur between two dates (Say, during the month of September, so between 09/01/2004 and 09/30/2004). I can't figure out how do use sumif with two arguement (sumif criteria is THIS AND THIS)? You'll get some answers suggesting SUMPRODUCT, which is fine. The *easiest-to-understand* way is ... use 2 SUMIFs, ie: SUMIF(less than 1st Oct 04) *minus* SUMIF(less than 1st Sept 04). Rgds, Andy |
#3
|
|||
|
|||
Assuming that Column A contains the date, and Column B contains the
expense amount, try the following... =SUMPRODUCT(--(A1:A100=DATE(2004,9,1)),--(A1:A100<=DATE(2004,9,30)),B1:B 100) or =SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),B1:B100) ....where C1 contains your start date, and D1 contains your end date. Hope this helps! In article , "Kellyatisl" wrote: I want to use the sumif function to add up all expenses that occur between two dates (Say, during the month of September, so between 09/01/2004 and 09/30/2004). I can't figure out how do use sumif with two arguement (sumif criteria is THIS AND THIS)? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the sumif if I have multiple criteria (i.e. greater .
With Excel 2007 you have a new function, SUMIFS(). It allows upto about 15
separate criteria, so for example with date1 in B2 and date2 in B3, =SUMIFS(sum_range,criteria1_range,""&B2,criteria2 range,"<="&B3) would return the desired sum. "Kellyatisl" wrote: I want to use the sumif function to add up all expenses that occur between two dates (Say, during the month of September, so between 09/01/2004 and 09/30/2004). I can't figure out how do use sumif with two arguement (sumif criteria is THIS AND THIS)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf Function using multiple criteria | Excel Worksheet Functions | |||
sumif with multiple criteria | Excel Worksheet Functions | |||
How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
SUMIF multiple criteria in 1 range | Excel Worksheet Functions |