How do you use averageif in excel?



How do you use averageif in excel?..

Answer / Rakesh Kumar Singh

In Excel, to use AVERAGEIF function, you can follow this syntax: AVERAGEIF(range, criteria, [array]) where range is the set of cells you want to average, criteria is the condition for the cells to be included in the average calculation (this should be a logical value or a reference to a cell containing a logical value), and array is an optional argument specifying the area to perform the average calculation on. If not provided, it defaults to the range specified.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What does pound sign mean in excel?

1 Answers  


What is the purpose of scenario manager in excel?

1 Answers  


How do I mass delete in excel?

1 Answers  


How do you use lookup function in excel 2016?

1 Answers  


How do you wrap a cell in excel?

1 Answers  


How do you merge cells in excel ios?

1 Answers  


How do I format an excel spreadsheet for printing?

1 Answers  


How do we remove #value in excel?

1 Answers  


What does #value mean in excel?

1 Answers  


How do I link cells in excel?

1 Answers  


What are the benefits of ms excel?

1 Answers  


How do you find exact match in excel?

1 Answers  


Categories