Monthly subtotals

S

Segovia

I have a spreadsheet in exel 2003 with data entered by date - dd/mm/yyyy.
How can i get monthly sub totals? At the moment if i sort by change in month
it gives me a subtotal for every day (not real usefull)
 
P

Pete_UK

Enter this formula in a helper column:

=MONTH(A1)

and copy down, assuming your dates are in column A. Then when you do
Data | Subtotals look for each change in the helper column. If you
want the names of the months rather than the numbers, you can use this
formula:

=TEXT(A1,"mmm")

Hope this helps.

Pete
 
Top