It can be done, but it is not entirely clear from your example how your
data is stored. Is the March 06 a date or a text string?
If it is a date and the dates are stored in b2:b5 and the values you
wish to sum are in c2:c5 try
=SUMPRODUCT((MONTH(B2:B5)=3)*(C2:C5))
3 being march
Or if you want to type mar
=SUMPRODUCT((TEXT(B2:B5,"mmm")="Mar")*(c2:c5))
If it is text
=SUMPRODUCT((LEFT(b2:b5,3)="Mar")*(c2:c5))
If you need to sum for each month you could just put the months in a
cells and reference that cell rather than type mar, apr etc
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=522071