Thread: How do update formula when change a number in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do update formula when change a number in another cell
=SUM(A:A) provided there is nothing else in column A

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Duma" wrote in message
...
Version: Excel 2003

If I have a column of numbers how do I change the total automatically if I
enter a different number into one of the cells in the column?




Reply With QuoteReply With Quote