MAX Function in Excel: Largest Value in a Range
MAX returns the largest number. MIN is its mirror. Both ignore text and blanks.
Read article →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 →SUM Function in Excel: Add Numbers, Ranges and Whole Columns
SUM Function in Excel: Add Numbers, Ranges and Whole Columns
SUM adds numbers, cell references and ranges. It ignores text and empty cells, which makes it the safest way to total a column.
Read article →