Remember Me?

#1
 Frannie21 Posts: n/a
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
 Aladin Akyurek Posts: n/a

=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
 JE McGimpsey Posts: n/a

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
 Bernard Liengme Posts: n/a

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
 JE McGimpsey Posts: n/a

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:

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 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 Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 05:17 AM BMWPRO Excel Worksheet Functions 1 December 6th 04 08:26 PM D@annyBoy Excel Worksheet Functions 5 December 2nd 04 01:37 PM pfdubz Excel Worksheet Functions 6 December 1st 04 07:40 PM Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM

All times are GMT +1. The time now is 05:46 PM.