by Excel provides various functions to perform essential calculations on your data. These functions are useful for summarizing and analyzing datasets.
1. SUM Function
SUM function is used to calculate the total of a range of numbers.
Syntax: =SUM(number1, [number2], …)
2. MIN Function
MIN function returns the smallest value in a given range of numbers.
Syntax: =MIN(number1, [number2], …)
3. MAX Function
MAX function returns the largest value in a given range of numbers.
Syntax: =MAX(number1, [number2], …)
4. COUNT Function
COUNT function counts the number of cells that contain numerical values in a range.
Syntax: =COUNT(value1, [value2], …)
5. AVERAGE Function
The AVERAGE function calculates the arithmetic mean of a group of numbers.
Syntax: =AVERAGE(number1, [number2], …)
One thought on “Performing Calculations by using the SUM, MIN, MAX, COUNT and AVERAGE functions”