John Meyer wrote:
Rob Clement wrote:
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
Actually, there are other types of trips that are on there. I will look
into the pivot table idea, though.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
John
I think that the other types of trips would be more easily handled by
putting in more "other columns" rather than using a pivot table. I think
that the day by day design has the benefit of simplicity.
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
