Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average

Functions

A very important feature in Excel is the formula. It is used to calculate values based on what is in cells, perform operations on a cell content, fetch values after an operation based on your search criteria and much more.

Mathematical Formulas in Excel are used to perform various arithmetic operations like sum, average, count, max, min etc. Here is a list of most frequently used mathematical formulas in excel.

Sum

This function is used to adds all the values within a cell range.

=Sum(number1, number2, ...)

Sumif

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria

=Sumif(Range, Criteria, Sum_Range)

Sumifs

The SUMIFS function, one of the math and trig function, adds all of its arguments that meet multiple criteria.

=Sumifs(Sum_Range, Criteria_Range1, Criteria1, Criteria_Range2, Criteria2, ..)

Count

The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments.

=Count(Value1, Value2, ...)

Countif

COUNTIF is a function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria.

=Countif(Range, Criteria)

Counta

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

=Counta(Value1, Value2, ...)

Max

The Microsoft Excel MAX function returns the largest value from the numbers provided.

=Max(Number1, Number2, .....)

Min

The Microsoft Excel MAX function returns the smallest value from the numbers provided.

=Min(Number1, Number2, ....)

Average

The Microsoft Excel MAX function returns the average value from the numbers provided.

=Average(Number1, Number2, ...)