Thread: Is there a way to automatically change the location of a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Is there a way to automatically change the location of a formula?
If there is nothing else in column A, then in any cell in B use =SUM(A:A)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"swright" wrote in message
...
I am working on a spreadsheet for my supervisor. He wants the program to
be
able to calculate the total right below the amount of items he enters.
However, he may enter 1 item or 25. Is there some way to do this?


Reply With QuoteReply With Quote