You can also use Pivot Tables. They are magical and can do just about anything.
Oh, but I think they are called DataPilot in Ooffice. Shaun On Sun, Jul 20, 2008 at 8:39 AM, Rob Clement <[EMAIL PROTECTED]> 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 > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]