How-to AverageIf Excluding Zeros and Blanks for Non Contiguous Ranges in Excel

Download the Sample File: http://exceldashboardtemplates.com/ho...
Learn 2 different ways to calculate an average if that will exclude zeros and blanks for a Non-Contiguous Range.

• #education
• #excel
• #averageifs
• #averageif
• #index
• #frequency
• #function
• #formula
• #non_contiguous_range
• #ignore_zeros
• #ignore_blanks