Thread: subtotals
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default subtotals
Typo:
=sumproduct((month(a2:a200)=3)*b2:b22)

Think it was meant as:
=SUMPRODUCT((MONTH(A2:A200)=3)*B2:B200)

Ranges have to be identically sized
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote