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

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

THE EXCEL LIBRARY

Explore more practical techniques for charts, formulas and dashboards.

Find a tutorial

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

SpreadSheet for AverageIf Exclude Zeros and Blanks Challenge

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.