COUNTIF Function In Excel

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

3 Count All Office Boy
 

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 



You May Also Like 


Post a Comment

0 Comments