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?