How to Calculate Average Ignore Blank and Zero Cells in Excel

preview_player
Показать описание
This post will guide you on how to calculate average while ignoring blank and zero cells in Excel. By default, Excel's AVERAGE function includes all cells in the specified range, including blank cells and cells that contain zero values

#########
#########
Рекомендации по теме
Комментарии
Автор

whenever i have completely blank cells, i always get an error. there must be at least one cell with a number for this to work.
is there a way to have a clean sheet and still enter a average formula without getting an error ?

maarrsseelli