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

Formula Auditing Option in Ms-Excel

Partner Ship Table in Ms-Excel

Goal Seek Option in Ms-Excel

How to Prepare Charts in Ms-Excel

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

Arithmetic Functions in Ms-Excel

How to Apply Formulas in Ms-Excel

How to use Object in Ms-Excel

Working on Employee Table in Ms-Excel

Freeze panes & Split in Ms-Excel

Wrap Text & Merge and Center in Ms-Excel

Fill & Clear Options in Ms-Excel

Logical Functions in Ms-Excel

Number Group Options in Ms-Excel

leave a comment

Cancel reply