Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kellyatisl
 
Posts: n/a
Default 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   Report Post  
Andy Brown
 
Posts: n/a
Default

"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   Report Post  
Domenic
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fgrose
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SumIf Function using multiple criteria Jamie A Miller Excel Worksheet Functions 1 February 4th 05 06:14 PM
sumif with multiple criteria benb Excel Worksheet Functions 3 January 6th 05 12:07 AM
How do I sum (like sumif) but predicated on multiple criteria, in. djpaik Excel Worksheet Functions 2 January 1st 05 02:12 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM
SUMIF multiple criteria in 1 range Mike@Q Excel Worksheet Functions 5 November 26th 04 04:55 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"