Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 4th 05, 12:37 AM
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  
Old March 4th 05, 12:48 AM
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  
Old March 4th 05, 12:53 AM
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  
Old June 4th 06, 06:33 AM 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 05:14 PM
sumif with multiple criteria benb Excel Worksheet Functions 3 January 5th 05 11:07 PM
How do I sum (like sumif) but predicated on multiple criteria, in. djpaik Excel Worksheet Functions 2 January 1st 05 01:12 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 1st 04 11:49 PM
SUMIF multiple criteria in 1 range [email protected] Excel Worksheet Functions 5 November 26th 04 03:55 PM


All times are GMT +1. The time now is 08:30 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017