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.
This function is used to adds all the values within a cell range.
=Sum(number1, number2, ...)
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)
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, ..)
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments.
=Count(Value1, Value2, ...)
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.
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, ...)
The Microsoft Excel MAX function returns the largest value from the numbers provided.
=Max(Number1, Number2, .....)
The Microsoft Excel MAX function returns the smallest value from the numbers provided.
=Min(Number1, Number2, ....)
The Microsoft Excel MAX function returns the average value from the numbers provided.
=Average(Number1, Number2, ...)