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
|