About Us

Sandy Mann

"daddylonglegs"
wrote in message
news:daddylonglegs.2c4k43_1154878207.9263@excelfor um-nospam.com...

...or you could do the same with SUMPRODUCT....

=SUMPRODUCT(--(A3:A262<=TODAY()),--(A3:A262TODAY()-DAY(TODAY())),Q3:Q262)

Yes good thinking. I started trying SUMPRODUCT() but I was fixated on the
MONTH() function.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.uk

"daddylonglegs"
wrote in message
news:daddylonglegs.2c4k43_1154878207.9263@excelfor um-nospam.com...

...or you could do the same with SUMPRODUCT....

=SUMPRODUCT(--(A3:A262<=TODAY()),--(A3:A262TODAY()-DAY(TODAY())),Q3:Q262)

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568750

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MAX figure within a date range as a function of today()'s date	irvine79	Excel Worksheet Functions	6	February 20th 07 03:28 PM
How to use Date range function in Sum(if....)	Murugan	Excel Discussion (Misc queries)	3	August 4th 06 11:58 PM
date function	[email protected]	Excel Discussion (Misc queries)	0	March 21st 06 11:37 PM
Match function...random search?	Les	Excel Worksheet Functions	10	July 28th 05 11:54 AM
Date range criteria and Pivot tables (again!)	DerbyJim1978	Excel Worksheet Functions	3	July 13th 05 10:14 PM