close
Copy the formula for the second total to the right by dragging the fill
handle (small solid square in lower right of active cell)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
quot;JClarkquot; gt; wrote in message
...
gt; Hello Group:
gt; I have a problem. I used the AutoSum function (Capital Sigma) to total
gt; a column, so I don't have to keep changing the sum formula when I add
gt; extra rows. My problem is that when I get to the third column, Autosum
gt; adds the totals of the first two rows rather than the total of the
gt; third column. How do I tell autosum to add vertically rather than
gt; horizontally?
gt;
gt; Many thanks!
gt;
gt; Jack
全站熱搜
留言列表
