Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frannie21
 
Posts: n/a
Default SUMIF function - criteria of between two dates. How?

When using the SUMIF function it allows a criteria from one colomn. How do
you right that to be between two dates.
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

=SUMIF(DateRange,"="&X2,SumRange)-SUMIF(DateRange,""&Y2,SumRange)

where X2 <= Y2, calculates a total for dates that are between X2 and Y2
inclusive.

Frannie21 wrote:
When using the SUMIF function it allows a criteria from one colomn. How do
you right that to be between two dates.

  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

=SUMPRODUCT(--(A1:A100DATE(2005,1,1)), --(A1:A100<TODAY()), B1:B100)

See

http://www.mcgimpsey.com/excel/doubleneg

for an explanation of the "--"

In article ,
Frannie21 wrote:

When using the SUMIF function it allows a criteria from one colomn. How do
you right that to be between two dates.

  #4   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Correction to link:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JE McGimpsey" wrote in message
...
one way:

=SUMPRODUCT(--(A1:A100DATE(2005,1,1)), --(A1:A100<TODAY()), B1:B100)

See

http://www.mcgimpsey.com/excel/doubleneg

for an explanation of the "--"

In article ,
Frannie21 wrote:

When using the SUMIF function it allows a criteria from one colomn. How
do
you right that to be between two dates.



  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Thanks for the correction - the other will also work if you include the
..html (my browser adds it if necessary).

In article ,
"Bernard Liengme" wrote:

Correction to link:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

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 Criteria Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 05:17 AM
how do you do a sumif function on more than one worksheet? BMWPRO Excel Worksheet Functions 1 December 6th 04 08:26 PM
can I use a range of dates as a criteria when using sumif? D@annyBoy Excel Worksheet Functions 5 December 2nd 04 01:37 PM
using logical functions as criteria with the SUMIF function pfdubz Excel Worksheet Functions 6 December 1st 04 07:40 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 09:38 AM.

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

About Us

"It's about Microsoft Excel"