Can I have a cell were each person can add a value and it calculates the average?
So me and my friends are creating a spreadsheet of our favourite restaurants and I was wondering if there's a way for each person to rate a restaurant in the same cell and it gives us the average of our votes.
Posted Mar 11, 2018, 10:38 PM UTC
11
Hard to do in the same cell on the same sheet but if you each have your own sheet with the cell being in the same place on each then the formula would look like this:
=average(‘OP!’B2, ‘Friend2!’B2,, ‘Friend3!’B2, ‘Friend4!’B2, ‘Friend5!’B2)
Edit: moved the exclamation points for accuracy