Try it like this:

=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)

--
Biff
Microsoft Excel MVP


"Curtis" wrote in message
...
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