Menu

How do I put more than one criterion in a SUMIF function?

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Ron Rosenfeld

Posts: n/a

Default

On Tue, 31 May 2005 15:59:24 -0700, "Bryan Brassell" <Bryan
wrote:

Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif.

=SUMIF(range, "" & DATE(2004,12,31), sum_range) -
SUMIF(range,"=" & DATE(2005,2,1), sum_range)

or (which seems slightly more clear to me, assuming you want data from Jan
2005):

=SUMIF(range, "=" & DATE(2005,1,1), sum_range) -
SUMIF(range, "" & DATE(2005,1,31), sum_range)

--ron

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to use SUMIF to return sums between two values located in cells	ScottBerger	Excel Worksheet Functions	2	April 23rd 23 09:05 PM
How do I use the sumif if I have multiple criteria (i.e. greater .	Kellyatisl	Excel Worksheet Functions	3	June 4th 06 06:33 AM
Dynamic sumif function	Jimbola	Excel Worksheet Functions	5	May 4th 05 01:10 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Excel Worksheet Functions	2	January 11th 05 11:01 PM
SUM(IF( Array to avoid #NUM! values	Elijah	Excel Worksheet Functions	7	November 21st 04 02:17 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement