Thread: sumproduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default sumproduct

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