PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

GOOGLE SHEETS FUNCTION-COUNTIF

INTRODUCTION

COUNTIF function , as the name suggests, does the counting job in GOOGLE SHEETS , just like the COUNT FUNCTION with the difference that we can provide condition in COUNTIF FUNCTION which cells to count.

The other difference is that it works independently of the type of data which means that it would work for numbers as well as text or any other data type.

COUNTIF FUNCTION is very helpful when we need to use any nested functions to make a check on the number of cells containing the number or number type of data.

 
 

Let us learn ,how to use COUNTIF FUNCTION IN GOOGLE SHEETS .

 

WHAT COUNTIF FUNCTION DOES IN GOOGLE SHEETS

COUNTIF FUNCTION returns the total number of cells from a given data set or range which fulfill a particular given criteria or condition.

PREREQUISITES TO LEARN COUNTIF FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the STATISTICAL terms is an advantage for the use of such formulas.
  •  Of course, GOOGLE SHEETS access.
  • If you already have some experience with any spreadsheet software.

 

SYNTAX OF COUNTIF FUNCTION IN GOOGLE SHEETS

The Syntax for the function is

=COUNTIF(RANGE, CRITERIA)

RANGE Given range which needs to be scanned to find out the number of cells which fulfill the criteria

CRITERIA The criteria on the basis of which , cells will be counted.

NOTE* CRITERIA NEEDS TO BE GIVEN IN THE “”.

 

EXAMPLE: COUNTIF FUNCTION IN GOOGLE SHEETS

DATA SAMPLE

Let us take a mixed data consisting of numbers, dates, numbers as text and text etc. so that we can check the working of function COUNTIF by giving different criteria.

The data used is shown below.

DATA
12
15
20
HI
I
LOVE
GOOGLE
SHEETS
HELLO
HIRE
FIRE
WIRE
TYRE
LIAR
23
435
56
76
87
43

We’ll find out the cells which has value LESS THAN 20

and

The cells which has value less than 12 OR greater than 400.

And finally using a wildcard will find the words which has RE at the end as suffix.

countif function google sheets
USING COUNTIF FUNCTION IN GOOGLE SHEETS WITH WILDCARDS

STEPS TO USE COUNTIF FUNCTION-EXAMPLE

STEPS:

1. Place the cursor in the cell and type the following function

CRITERIA 1: <20

=COUNTIF(C5:C24,“<20”)

2. Press ENTER, the answer will appear as 2.

3. Place the cursor in the cell and type the following function

CRITERIA 2: <12 or >400

=COUNTIFC5:C24,“<12”)+COUNTIF C5:C24 ,” >400 ” )

*If there are two conditions, its better to make a logic like the one we made. It fulfills the conditions but the condition is single.

4. Press ENTER, the answer will appear as 1 as there is no values less than 12 and only one value greater than 400.

5. Place the cursor in the cell and type the following function

CRITERIA 3: WORDS ENDING WITH “RE” [USING COUNTIF TO USE WILDCARDS IN GOOGLE SHEETS]

=COUNTIF(C5:C24,“*RE”)

6. Press ENTER, the answer will appear as 4.

The answers can be checked manually. We find that all answers are correct.

 
 

generalized STEPS TO USE COUNTIF function

HERE ARE THE STEPS TO USE COUNT FUNCTION
  • Type the function
  • =COUNTIF(RANGE, CRITERIA)  in the cell where we want the result.
  • Press ENTER and the result will appear.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: