Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Statistics

AVERAGE

  • May 31, 2023
Definition: AVERAGE is a function that returns the arithmetic mean of a list of numbers. Syntax: =AVERAGE(number1, [number2], ...) Situation: This formula is suitable when you need to...
Read More

AVERAGEA

  • May 31, 2023
Definition: AVERAGEA is a function that returns the arithmetic mean of a list of values, including text and logical values. Syntax: =AVERAGEA(value1, [value2], ...) Situation: This formula is...
Read More

AVERAGEIF

  • May 31, 2023
Definition: AVERAGEIF is a function that returns the average of a range of cells that meet a specified criterion. Syntax: =AVERAGEIF(range, criteria, [average_range]) Situation: This formula is suitable...
Read More

AVERAGEIFS

  • May 31, 2023
Definition: AVERAGEIFS is a function that returns the average of a range of cells that meet multiple specified criteria. Syntax: =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...) Situation: This...
Read More