Here, we will describe the simple formulas to calculate the average of a given range that is not blank in Excel Office 365. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To calculate the average if criteria not blank in Excel, use the below formula.
=AVERAGEIFS(range1,range2,”<>”)
Syntax Explanations:
- AVERAGEIFS – This function will return the average of a set of input values that meet the multiple criteria. Read more on the AVERAGEIFS Function.
- Range – It represents the input value from your worksheet.
- Comma symbol (,) – It is a separator which helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
- Now we are going to see how to calculate the average.
- Refer to the below image.
- Here, we will give the input values in Column C and Column D.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the result in cell G3.
Bottom-Line:
From this tutorial, we guided you to learn the simple formulas used to calculate the average of a given range that is not blank in Excel Office 365. Hope that this article is useful to you. If you have any suggestions, feel free to share it with us. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!
Top comments (0)