Excel Statistical Functions:

Explained with Examples.

  • AVERAGEIF: AVERAGEIF is a Logical Function. AVERAGEIF Function in Excel find the Average of all numbers in a range based on a given criteria
  • COUNTIF: COUNTIF is a Logical Function. COUNTIF Function in Excel counts all numbers in a range based on a given criteria