close

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?

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

HTH
Michael

quot;Cosmoquot; wrote:

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

Thank You Very Much!

quot;Michael Mquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()