Monthly subtotals
 

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)

Monthly subtotals
 

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

On Jun 11, 3:16*am, Segovia wrote:
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)