Count Function in excel

Formula always begins with this symbol

• =

• *

• %

• @

There are three types of count function

• False

• True

This function is used to count the cell that contains only numbers.

• Count

• CountA

• CountIF

• Cell reference

This function counts everything(Alphanumeric data) in the cell range except empty cells.

• Count

• CountA

• Countif

• Cell Range

This is used to count the number of cells that meet a specific criteria/condition

• Count

• CountA

• CountIF

• Cell range

Criteria in COUNTIF() function is always written in

• Double Quotes

• Single quotes

• semi-colom

What will be the result if the formula =Count(A1:A6) is applied

• 2

• 3

• 4

• 5

What will be the result if the formula =CountIF(D5:D12, “>100”) Is applied to cells

• 2

• 3

• 4

• 5

What will be the result if the formula = CountA(A1:A6) is applied

• 4

• 5

• 6

• 7