MAX Function in Excel: Largest Value in a Range
StatisticalLevel: BeginnerAvailable in: Excel 2007+MAX returns the largest number. MIN is its mirror. Both ignore text and blanks.Syntax=MAX(number1.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
COUNTA Function in Excel: Count Non-Empty Cells
COUNTA Function in Excel: Count Non-Empty Cells
COUNTA counts every cell that is not empty — numbers, text, errors and even formulas that return an empty string.
Read article →COUNT Function in Excel: Count Cells That Contain Numbers
COUNT Function in Excel: Count Cells That Contain Numbers
COUNT counts cells containing numbers (including dates, which are numbers in Excel). Text and blanks are not counted.
Read article →AVERAGE Function in Excel: Arithmetic Mean of Numbers
AVERAGE Function in Excel: Arithmetic Mean of Numbers
AVERAGE returns the arithmetic mean: the sum divided by the count of numbers. Empty cells and text are ignored, but zeros are counted.
Read article →