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

#### CONTENTS

# EXCEL FUNCTIONS-COUNT

## INTRODUCTION

*COUNT FUNCTION comes under the STATISTICAL FUNCTIONS category in Excel.*

*COUNT function , as the name suggests, does the counting job in Excel. It counts the numbers, dates, number stored as text only and skips every other data.*

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

*One more usage of this function will be when we start learning VBA, we’ll be needing a lot of functions to know the status of the sheet so that we can decide what to do further.*

*Let us learn ,how to use this function.*

## PURPOSE OF COUNT FUNCTION IN EXCEL

**COUNT FUNCTION returns the total number of cells containing number, dates or number in text format in a given range.**

## PREREQUISITES TO LEARN AVEDEV 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, Excel software.

## SYNTAX: COUNT FUNCTION

**The Syntax for the function is**

**=COUNT(cell1, cell3, cell3….) or**

**=COUNT(cell1 : cell2) direct range **

**cells **These are the data. It can be a cell address, or value, or a date directly or contained in a cell.

## EXAMPLE:COUNT FUNCTION IN EXCEL

### 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 COUNT.

The data used is shown below.

1 |

2 |

3 |

ASH |

HELLO |

23 |

34 |

65 |

876 |

GHJ |

12 |

QW |

01-03-2020 |

“23432” |

### STEPS TO USE COUNT FUNCTION-EXAMPLE

STEPS:

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

=COUNT(D6:D19)

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

3.For manually checking the answer, we tried to find the individual results too. For that we put

=COUNT(D6) in the cell E6 and dragged to get the result for every data. We counted the number and it came out to be 9 which proves the function.

*NOTE: There was a discrepancy with this kind of data “54641”. The function didn’t treat it as a number. So be very clear that if this data is given to the function through the ARRAY OR RANGE, it won’t be treated as number but if given directly as a value, it’ll be treated as a number.

### GENERALIZED STEPS TO USE COUNT FUNCTION

- Type the function
- =COUNT(DATA1, DATA2….) OR COUNT(RANGE) 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

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.