Let’s learn about mostly used function (HOW TO USE COUNT FORMULA IN ADVANCE EXCEL) COUNT formula today, COUNT Function is basically used to calculate Numerical Values & Alphabetical Values by Applying Different version of Formulas. The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Let’s start with Syntax to be used in COUNT Formula:
Some Tips to Use COUNT Formula:
Arguments that are numbers, dates, or a text representation can be counted. Empty cells, can be counted with COUNTBLANK Function. If you want to count logical values, text, or error values, use the COUNTA function. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
Let us Discuss what we are going to Learn today
FORMULA TO BE LEARNED TODAY
2 . COUNTA
3 . COUNTBLANK
4 . COUNTIF
5 . COUNTIFS
FORMULA NO 1: COUNT
To Learn how to apply COUNT Formula, first we need to prepare data, Here we have prepared Sales data of Different brands of Mobiles & LED, as Shown in Figure below:
COUNT formula used to count number of items you have in your list, so if you want to calculate number of items you have entered in your list, you can simply use COUNT formula
First Step is to click on the blank cell where you want your answer, then apply formula =COUNT(Cell range), Select cells you want to Calculate. Reference Shared in Pic below, you can see it has not calculated any alphabets or Blank Cells, Only Numerical value is counted.
FORMULA 2: COUNTA
This function is widely used to calculate count of Numerical as well as alphabetical Values in Selected cells.
You have to select the data you want to count then apply formula =COUNTA(Cell range), it will calculate all values Excluding empty Cells. Example given in picture below:
FORMULA 3: COUNTBLANK
In the formula above, it counts only Blank cells
FORMULA 4: COUNTIF
COUNTIF is used to count the number of cells that meet a certain Criteria:
To count the number of times a particular city appears in a customer list.
For single criteria – We use the above formula
=COUNTIF(Where you want to look & what you want to look for?)
In the example below, lets filter Count of LED in Product list.
First Apply formula =COUNTIF,
Select Range of Product, & then select the Product type you want to Count.
FORMULA 5: COUNTIFS
The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
For Multiple criteria – we use COUNTIFS
=COUNTIFS(range of first criteria, cell reference from first criteria, Range from Second Criteria, cell reference from Second Criteria). If we need to count particular Product under certain Brand name, we will use COUNTIF Function.
In Example in picture below, we will Count Number of Mobiles we have Under Nokia Brand.
Now i hope you will Understand HOW TO USE COUNT FORMULA IN ADVANCE EXCEL. and if your really liked it,
Miss Priyanka Dhiman