I do not use excel very often but know there is a simple formula to take the average of numbers inputted into a column. For example, I would like to sum all the values entered into column “D” and then divide that by the number of entries
4
5
3
1
4
11
6
2
0
----
36/9 = 4
If I were to add another entry it would automatically change the divisor to 10
Any suggestions would be helpful
Thanks a lot
John
Bookmarks