How To Use Excel COUNTBLANK Function – A Complete Tutorial

Given a set of data, we might want to find out the count of all the blank cells from a particular range. Excel COUNTBLANK function can be of used to achieve the same. Let’s see how to do it…!!! 1. What is the COUNTBLANK Function? 2. What is the Syntax? 3. How to use it … Continue reading How To Use Excel COUNTBLANK Function – A Complete Tutorial

How To Use Excel COUNTA Function – A Complete Tutorial

Given a set of data, we might want to find out the count of all the Non-blank cells from a particular range. Excel COUNTA function can be of used to achieve the same. Let’s see how to do it…!!! 1. What is the COUNTA Function? 2. What is the Syntax? 3. How to use it … Continue reading How To Use Excel COUNTA Function – A Complete Tutorial

What Is Excel COUNTIFS Function – A Quick Guide

Suppose we have a class of 10 students and each one of them have opted for different subjects as per their choice. Now, what if we want to find the number of students opting a particular subject in combination with the region he belongs to!!! Excel COUNTIFS can do the work for us… Let’s see … Continue reading What Is Excel COUNTIFS Function – A Quick Guide

What Is Excel SUMIF Function – A Complete Guide

Suppose you want to add a few numbers based on certain criteria. How will you approach it? I will surely rush back to SUMIF function… 🙂 Let us see how to use it in detail… 1. What is the SUMIF Function? 2. What is the Syntax? 3. How to use it with an example? 1. … Continue reading What Is Excel SUMIF Function – A Complete Guide

What Is Excel SUM Function – How To Use It?

It can be during complex financial calculations or simple daily math, we can’t escape the addition of numbers. SUM function of excel can help us with that!!! Let us see how to use it in detail… 1. What is the SUM Function? 2. What is the Syntax? 3. How to use it with an example? … Continue reading What Is Excel SUM Function – How To Use It?

How To Use Excel COUNT Function – A Quick Guide

Having given a set of data which include different data types, If I ask you to find the total count of numbers in it. How will you do that? For sure I will pick COUNT function…!!! Let us see how to use it in detail… 1. What is COUNT Function? 2. What is the Syntax? … Continue reading How To Use Excel COUNT Function – A Quick Guide