Thread
:
subtotals
View Single Post
#
6
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
subtotals
Thanks for the catch
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Max" wrote in message
...
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 Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett