=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=C2),B1:B100)
=SUMPRODUCT(--(MONTH(A1:A100)=C3),B1:B100)
this assumes C3 will hold the Month NUMBER.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Brisbane Rob"
wrote in message
news:Brisbane.Rob.24miky_1142279102.0707@excelforu m-nospam.com...
Hi
I have two columns, A containing dates from January 1 to December 31,
and B containing values entered against the dates.
Without creating range names, what's the shortest formula to:-
1. sum the values between any two given dates (contained in say cells
C1 and C2)
2. the total for any given month nominated in say C3
Thanks for any ideas
--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=521866