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