How to total like items
 

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?

How to total like items
 

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?

How to total like items
 

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?