Mangesh's proposed formula looks good - only comment I would make is
that it will sum the month across several years if the data table
includes multiple years. To remedy this, just add on more section
identical to the Month section, but replacing 'month' with 'year' like
follows:

=SUMPRODUCT(--(MONTH($A$1:$A$10)=MONTH(G$1)),--(YEAR($A$1:$A$10)=YEAR(G$1)),--($B$1:$B$10=$F2),$C$1:$C$10)

Also, one question for my benefit - I've noticed that some people use
the '--' with conditional sumproducts - I've always just replaced the
',' with '*'. I was wondering if there is any advantage/disadvantage
of using one way or the other. Thanks, Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=380043