"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