How can I "void" a cell from a column to give me the correct average?

Published: 10/10/2019
How can I "void" a cell from a column to give me the correct average?
Source: WEBAPPS.STACKEXCHANGE.COM

Google Pages. I need my page set up for 20 rows of data on a google spreadsheet (forgive my ignorance) Often I need to only input 15 or so rows of data. Sheets spits out an average at the bottom of each column that is based on all 20 cells (and factors the empty cells as a zero). If I have a blank cell how do I remove it from the average?

Read more
Related news
Comment
FACEBOOK