John Meyer wrote:
i have a spreadsheet set up with the miles that I've biked on a
particular day. What I want is to the side to get a grouping of those
entries by day and the sum. I can do it with subtotals but that
inlines them with the data where i want the totals to the side.
The data looks like this, btw:
Date Miles
To work 07/18/08 3.2
To home 07/18/08 3.2
To work 07/19/08 3.2
To home 07/19/08 3.2
John
Can I suggest a different format of the data
Date to work from work other total
07/18/08 3.2 3.2 0 6.4
07/19/08 3.2 3.2 0 6.4
You can then easily use a sum function to sum the figures for the day.
You can add extra columns to show any other mileage you do.
I hope this will make the spreadsheet easier.
Thanks
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
