Here, we will show the formulas to calculate the average of a list and ignore the errors in Excel Office 365. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to calculate the average of a list in Excel.
=AVERAGEIF(values,”>=0″)
Syntax Explanations:
- AVERAGEIF – This function will return the average of a set of input values that meet the single criteria. Read more on the AVERAGEIF Function.
- Values – 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 of the given values.
- Refer to the below image.
- Here, we will give the input values in Column B.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the result in the selected cell D3.
Verdict:
From this tutorial, you can get some clarification on the formulas to calculate the average of the listed value that ignores the errors in Excel Office 365. Hope that this article is useful to you. If you have any suggestions, don’t forget to share it in the below comment box. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!
Top comments (0)