subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:c22)
 
Alternative.

Add a column to get the month (=MONTH(A2) for instance), and subtotal by
that column.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top