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

How to Apply Formulas in Ms-Excel

Cinema Tickets Table in Ms-Excel

Arithmetic Functions in Ms-Excel

Data Validation in Ms-Excel

Consolidate option in Ms-Excel

Conditional Formatting In Ms-Excel

Partner Ship Table in Ms-Excel

Flash Fill & Remove Duplicates

Power bill Table in Ms-Excel

Fill & Clear Options in Ms-Excel

Simple Macros in Ms-Excel

Auto Formulas in Ms-Excel

Logical Functions in Ms-Excel

Number Group Options in Ms-Excel

leave a comment

Cancel reply