Remember Me?

#1
March 4th 05, 01:37 AM
 Kellyatisl Posts: n/a
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
March 4th 05, 01:48 AM
 Andy Brown Posts: n/a

"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
March 4th 05, 01:53 AM
 Domenic Posts: n/a

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
June 4th 06, 06:33 AM posted to microsoft.public.excel.worksheet.functions
 fgrose Posts: n/a
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)?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jamie A Miller Excel Worksheet Functions 1 February 4th 05 06:14 PM benb Excel Worksheet Functions 3 January 6th 05 12:07 AM djpaik Excel Worksheet Functions 2 January 1st 05 02:12 PM Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM [email protected] Excel Worksheet Functions 5 November 26th 04 04:55 PM

All times are GMT +1. The time now is 06:47 PM.