Table of Contents
- How to Use SUM Function ?
- What is SUM Function?
- Step by Step Guide for SUM function
- How to Use AVERAGE Function ?
- What is AVERAGE Function ?
- Step by Step Guide For AVERAGE Function
- How to Use COUNT Function?
- Step by Step Guide For COUNT Function
- Watch Video Tutorial for SUM, AVERAGE and Count Formula
How to Use SUM Function ?
What is SUM Function?
The SUM function is an important mathematical function in Excel that calculates the sum (total) of a selected cell range or number range. This function is easy to use for everyone; you need to just select the cells you want to sum and use the SUM function. The general formula is =SUM(F3:F9).
For example, the =SUM(F3:F9) formula will calculate the sum of all the numbers in the range F3 to F9. This function is very useful in data analysis, budget management, and various financial calculations, saving time and effort.
=SUM(F3:F9)
Step by Step Guide for SUM function
In the screenshot below, you can see that we have taken an example in which we have mentioned the products and their per unit price, and added the total amount in the last column. In the Total field at the bottom, we will use the SUM formula.
First, we have to go to the cell where the total amount is to be added and press = there, as we have done in front of Total (you can see in the image). After this, we have to select the cells in brackets whose sum is to be calculated. For example, in the image below we have selected cells from F3 to F9.
In the second step, after selecting the cells range, press Enter. You can see that the total of all the products has appeared in front of Total. This is how you have to use the SUM function.
How to Use AVERAGE Function ?
What is AVERAGE Function ?
AVERAGE function is an important function in Excel that calculates the average of a selected range of cells or numbers. It is simple to use; you simply select the cells you want to average and use the AVERAGE function.
=AVERAGE(first cell:last cell).
For example, the =AVERAGE(F3:F9) formula calculates the average of all numbers from F3 to F9. This function is very useful in data analysis, test results, and various calculations, making it easy to find the central value of any number set.
Step by Step Guide For AVERAGE Function
Step 1: Click to the cell next to “Average” where you want to Average the number. For example, in the above image, it is the F10 cell.
Step 2: Type =AVERAGE( - in cell F10.
Step 3: Now select the cells you want to calculate the average of. In this case it is cells F3 to F9. So the formula will be =AVERAGE(F3:F9).
Step 4: Close the bracket and press Enter. Your final formula will be: =AVERAGE(F3:F9)
Step 5: On pressing Enter, the average will be displayed in cell F9, which is 163.5714286 in this case.
Thus, you have successfully calculated the average of the given data using the AVERAGE function.
How to Use COUNT Function?
The COUNT function is an important function in Excel that counts how many numbers are in a selected cell range. This function counts only cells that contain numeric data. It is simple to use; you simply select the cells you want to count and use the COUNT function. The general formula is =COUNT(first cell:last cell).
For example, the =COUNT(F3:F9) formula counts all numeric cells from F3 to F9. This function is very useful in data analysis and reporting, allowing you to easily get the total number of numeric data.
=COUNT(F3:F9)
Step by Step Guide For COUNT Function
Step 1: Click on the cell next to "Count" where you want to calculate the number. For example, in the above image, it is the F10 cell.
Step 2: Type =COUNT( in the F10 cell.
Step 3: Now select the cells whose number is to be counted. In this case it is cells F3 to F9. So the formula will be =COUNT(F3:F9)
Step 4: Close the bracket and press Enter. Your final formula will be: =COUNT(F3:F9)
Step 5: On pressing Enter, the count will be displayed in the F10 cell, which is 7 in this case.
Thus, you have successfully counted the number of the given data using the COUNT function.
0 Comments