Thread: subtotals
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default subtotals

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)



"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