Thread: sumproduct
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RGlade RGlade is offline
external usenet poster
 
Posts: 13
Default sumproduct

I'm just getting ready to try it. Thank you.

"Dave Peterson" wrote:

Check your other post.

RGlade wrote:

This is what I am using: =sumproduct((month(B5:B412)=1)*D5:D412)

I can't get this formula to work for February....etc. I need to use the
same range of cells.

Please help.


--

Dave Peterson