Average of Column

Kiley Murray

Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will be ongoing entries. If possible I just want to get the average of the whole column so I don't have to come back and update.

Thank You☺️

Khasim

Hi @Kiley Murray , You can try =AVG(Column name:Column name).

I hope it helps you.

Please accept and upvote the answer so that it can benefit users in our Smartsheet community.

Kiley Murray

Thank you Khasim! That worked by doing. I had to type it out, instead of just selecting the column.

=AVG([Primary Column]:[Primary Column])

DavidDumler

This still isn't fixed. Please address the issue of trying to average a column and needing to manually type in the formula - the user should be able to just click on any range to get the average, not have to type in manually.