Skip to content

▥Excel DashboardTEMPLATES

Dashboard School Consulting Services Subscribe Donate Search ⌕

Home/Friday Challenge – AverageIf NOT Blank or NOT Zero – NOT So Easy

Excel tutorial

SpreadSheet for AverageIf Exclude Zeros and Blanks Challenge

THE EXCEL LIBRARY

Explore more practical techniques for charts, formulas and dashboards.

Find a tutorial

Illustration from SpreadSheet for AverageIf Exclude Zeros and Blanks Challenge

Data for AverageIf Exclude Zeros and Blanks Challenge

AverageIf that Ignores Zeros and Blanks for a Non-Contiguous Data Range

Excel Dashboard Templates

Tutorials, free templates, formulas and chart resources
for your next Excel dashboard.

About Contact Privacy policy Search articles

Excel Dashboard TemplatesA practical reference for better spreadsheets.