I need to calcualte the volume totals by month. The data is compiled daily in
column J of sheet 2 (data)

=SUMPRODUCT(--('Feb-Aug09 Data'!$K$3:$K$1406=Summary!$A6)*--('Feb-Aug09
Data'!$I$3:$I$1406=C3)*('Feb-Aug09 Data'!$C$3:$C$1406))

Row 3 C thru N in my summary sheet contains the months in format mm/dd/yyyy.
Column I in my Data sheet contains all the dates asme format

I need to calcualte the volumes by month as identifed in sheet 2

Hope that makes sense

Thanks