View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default excel template automatic calculates

Hi

Your first sum formula in column F should look like this: =SUM(C1:E1)

change C to B: =SUM(B1:E1) and copy down or double click on the small black
cross in the bottom right corner of the cell.

Hope this helps!
Jean-Guy

"bobby02169" wrote:

Hello
i downloaded a template from excel that automatically calculates the totals
in each row and the last colum.
i would like to add a column and also have it calculate but i don't know how.
ex. column a+b do not calculate but column c,d,and e do calculate I would
like to make column be calculate.
I'm not sure if i explained this right,but any help will be appreciayed
Thanks
Bobby