How to total like items

[Cosmo]

I have a spreadsheet where I need to total certain sections. I use it to
total hours for each loaction. Some locations have multiple lines while
others only have one. How can I create a grand total for the locations with
more than one entry?

[Michael M]

Hi Cosmo
Have a look at Data/Subtotals
You can nominate where you want the subtotals to appear

HTH
Michael

"Cosmo" wrote:

> I have a spreadsheet where I need to total certain sections. I use it to
> total hours for each loaction. Some locations have multiple lines while
> others only have one. How can I create a grand total for the locations with
> more than one entry?

[Cosmo]

Thank You Very Much!

"Michael M" wrote:

> Hi Cosmo
> Have a look at Data/Subtotals
> You can nominate where you want the subtotals to appear
>
> HTH
> Michael
>
> "Cosmo" wrote:
>
> > I have a spreadsheet where I need to total certain sections. I use it to
> > total hours for each loaction. Some locations have multiple lines while
> > others only have one. How can I create a grand total for the locations with
> > more than one entry?