This tutorial explains, how to implement formula easily in the Excel.
How to get sum in excel using the sum formula.
If we need to add some values in excel then we use given below formula.
Your answer would be 5720 as per given below worksheet screenshot.
You can also use Alt + = as a shortcut for sum in excel.
How to get average in excel using the average function.
If we need to calculate the Average of defined numbers then we can use the average formula in excel.
Your answer would be 715 as per given below worksheet screenshot.
How to get the number of cell in the excel using count function
We use this formula for counting the cell in range that contains numbers. You can see the below related example.
How to get the cell without empty cell in the excel using countA
How to get the blank cell in the excel using COUNTBLANK
We use this formula for counting the blank cells in the specified range of data. You can see the below example to understand this.
It is showing that COUNTBLANK has counted the empty cell which is below Seeta. So the result became 1 because only one cell exists blank in the specified range.
Use of COUNTIF
We use this formula for counting the number of cells within a specified range that meets the given condition. You can see the below example to understand this better. Formula is for COUNTIF
You can see the example that we have applied a condition that we need to count the cell which has the name “Raja”. So results become 2 because as we can see that two cells contained the name “Raja”. So range is specified from B2: B7 & criteria is named “Raja”. You can try more different conditions in this formula.
Use of COUNTIFS
We use this formula for counting the cells which meets one or more different criteria. You can refer to the below example to understand this better. Formula for COUNTIFS is
You can see the above example that meets two conditions: one is for the name “Raja” from column B & second is for Class II from column C, the criteria meets two times so the result becomes 2. You can try more different conditions & comment for your suggestions & requirements.