ExcelBanter - Average

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Average (https://www.excelbanter.com/excel-discussion-misc-queries/99377-average.html)

timbrook

Average

I have a column of numbers thar I have averaged. If I change one of the
numbers I have to insert the average function again. Why?

Elkar

Average

Check to see if "Automatic Calculations" is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar

"timbrook" wrote:

I have a column of numbers thar I have averaged. If I change one of the
numbers I have to insert the average function again. Why?

All times are GMT +1. The time now is 12:38 AM.