COUNTIF Function In Excel
COUNTIF
Function In Excel is an Excel function
to use for count cells in a range that meet a single condition. The Countif
function return the number of repeated value in a range on a single condition.
Syntax
=COUNTIF
(range, criteria)
Arguments
Below shows
a table where stored data related to employee, Now I want to know how many Manager
, Accountant and Office Boy is in this data so here you can use COUNTIF function
in excel.
1 Count All
Manager
2 Count All
Accountant
1 Count All Manager
Formula Applied
In F1 Cell
Formula : =COUNITIF(B2:B13,E1)
2 Count All Accountant
Formula Applied
In F2 Cell
Formula : =COUNITIF(B2:B13,E2)
3 Count All Office Boy
Formula Applied
In F3 Cell
Formula : =COUNITIF(B2:B13,E3)
COUNTIF Function With Mix Reference (F4 Key)
Formula Applied
In F1 Cell
Formula : =COUNITIF(B2:B13,E1
Download Excel Sheet
