Excel Formulas & Shortcuts Tutorial

This tutorial explains, how to implement formula easily in the Excel.

How to get sum in excel using the sum formula.

Don't Miss

If we need to add some values in excel then we use given below formula.
=SUM (D42:D49)
Your answer would be 5720 as per given below worksheet screenshot.

sum_excel
You can also use Alt + = as a shortcut for sum in excel.

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.
=AVERAGE (D42:D49)
Your answer would be 715 as per given below worksheet screenshot.
average_excel

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.
count_of_excel

How to get the cell without empty cell in the excel using countA

In this example you can see that COUNTA has not counted the empty cell which is below Seeta. So result became 5.

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.
countBlank-min
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
=COUNTIF(range, criteria)
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
=COUNTIFS(Criteria_Range,Criteria………)
countifs

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

564FansLike

Recent Posts

How to Install & Setup the Java Development Kit (JDK)

If you do not have the newest JDK already put in in your pc, comply with the steps under. You have to have the JDK put in to run applications. To see which version of...

How to Setup Kotlin Plugin in Android Studio Tutorial

Kotlin is a programming language launched by JetBrains, the official designer of essentially the most intelligent Java IDE, named Intellij IDEA. One nice information of shifting to Kotlin is, you...

How to Parse Json in Android Application

JSON stands for JavaScript Object Notation.It is an independent data trade format and is the perfect various for XML. This chapter explains the way to parse the JSON file and...

Related Articles

How to Install & Setup the Java Development Kit (JDK)

If you do not have the newest JDK already put in in your pc, comply with the steps under. You have to have the JDK put in to run applications. To see which version of...

How to Setup Kotlin Plugin in Android Studio Tutorial

Kotlin is a programming language launched by JetBrains, the official designer of essentially the most intelligent Java IDE, named Intellij IDEA. One nice information of shifting to Kotlin is, you...

How to Parse Json in Android Application

JSON stands for JavaScript Object Notation.It is an independent data trade format and is the perfect various for XML. This chapter explains the way to parse the JSON file and...