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, ...)
Last updated