Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Formula Help

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