Averageif function in Excel

The structure of the Averageif function in Excel is Averageif(range, criteria, average range)

How to use the Averageif function in Excel

  • Got to the Excel function assistant
  • Select the Averageif function
  • Highlight the range that has the required information
  • Lock the cells
  • Select the criteria for analysis
  • For the average range select the data that holds the data to be averaged
  • Lock those cells
  • Both the range and the average range need to be the same seize
  • Hit Return

That´s it!

No comments yet.

Leave a Reply