Count Formulas in Ms-Excel – Computers adda

Latest News :

Count Formulas in Ms-Excel

In this video we can discuss about Some Count Formulas in below notes

1. COUNT ():-
It counts the only numerical cells in range of selection.
Syntax:-
=COUNT (A1:A10)

2. COUNTA():-
It not counts the empty cells in range of selection
Syntax:-
=COUNTA (A1:A10)

3.COUNTBLANK():-
It counts the only blank cells in range of selection.
Syntax:-
=COUNTBLANK (A1:A10)

4.COUNTIF():-
It counts the highest (or) least value cells on required.
Syntax:-
=COUNTIF (A1:A10,”<=5”)
(OR)
=COUNTIF (A1:A10,”>=5”)

durgaprasad

Related Posts

Filter Option in Ms-Excel

How to Prepare Charts in Ms-Excel

User interface of Ms -Excel

Text to Columns in Ms-Excel

Flash Fill & Remove Duplicates

Scenario Manager Option in Ms-Excel

Data Validation in Ms-Excel

Using Cell’s Basics(Fill handle) in Ms-Excel

How to Apply Formulas in Ms-Excel

How to Use Comments in Ms-Excel

Inventory Table in Ms-Excel

Using Spreadsheets in Ms-Excel

Logical Functions in Ms-Excel

Number Group Options in Ms-Excel

leave a comment

Cancel reply