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

I am using this function: =sumproduct((month(B5:B412)=1*D5:D412)

I can't get this function to work with Feburary, March....ect.

Basically I want "if B5:B412's date is January then add the cells in D5:D412
with the sum the D cells "answer" in cell E2"
Same with February, only answer in F2
Same with March, only answer in G2

What am I doing wrong?