View Single Post
  #4   Report Post  
Domenic
 
Posts: n/a
Default

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