Numbers Average Formula Help
What is the formula to get the average of a column that keeps growing? I place the formula in a header row.
[Edited by Moderator]
iMac 24″, macOS 15.5
Question marked as
Maybe I'm missing something, but assuming your numbers are in column B, and you have 1 header row, set cell B1 to:
=AVERAGE(B)
This will give you an average of all the values in column B, excluding any header or footer rows. Since you're tagging the entire column it will automatically incorporate any additional rows.