I've misunderstood what you're looking for. See if the following
helps...
1) First, make sure that each cell in Column A contains the month for
the corresponding day...
a) Select/highlight Column A
b) Edit Go To Special Blanks Ok
c) Press =
d) Hit the 'Up Arrow' key
e) Press CONTROL+ENTER
2) Then, use SUBTOTAL to give you your monthly subtotals...
a) Select your data, including your headers
b) Data Subtotals
At each change in: Month
Use function: Sum
Add subtotal to: check the appropriate header/column
Replace current subtotals: uncheck this option
Click Ok
Hope this helps!
In article ,
ChuckW wrote:
Domenic,
Thanks for your help. I am a novice excel user and am trying to figure out
how to do what you suggested. I got the weekly subtotal by using the
pulldowns. How would I do the monthly ones?
Thanks,
--
Chuck W
|