Thanks Dave

The formula now looks like this

=SUMPRODUCT(MONTH(Data!$C$2:$C$20000=2)*(Data!$C$2 :$C$20000=$A12)*(Data!$J$2:$J$200000)*Data!$J$2:$ J$20000)

However it reurns the same value for all months and iresepctive of refernece
$a12, $b12, etc...

Thanks

"Dave F" wrote:

Something like MONTH($C$2:$C$20000=3) would return the sum of all March values.

So, try something along the lines of =SUMPRODUCT(MONTH($C$2:$C$20000=3)[rest
of formula])

Dave
--
Brevity is the soul of wit.


"Curtis" wrote:

I am currently using the formula
=SUMPRODUCT((MAR_06!$C$2:$C$20000=$A70)*(MAR_06!$J $2:$J$200000)*MAR_06!$J$2:$J$20000)

Where Mar_06 = month ( sperate sheet)

What I would like is a formula that looks at column "c" and sum $$ by the
different months

Thanks

ce