Thread
:
subtotals
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
subtotals
BTW. You do NOT need to filter to use sumproduct.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett" wrote in message
...
try this for the month (if dates in col a) and data to sum in col b
=sumproduct((month(a2:a200)=3)*b2:b22)
to add another variable
=sumproduct((month(a2:a200)=3)*(b2:b22="joe")*c2:c 22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"kanstrup" wrote in message
...
Hello,
I have a list of dollar amounts corresponding with days in the months. I
am
trying to create a subtotal for each month and not each day of the month.
When I do subtotal I get a subtotal for each day of the month. How do I
get
a total just for the month?
Thanks,
Chris
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett