Answer by
murali680 (559)

Excel countif function is used to calculating of process and cells in a range that meets a given condition. Countif function written as CountIf( range, criteria). Criteria is used to calculate which cells to count. For example if we have number from 100 to 500 in a row, we could count how many numbers between 200 to 350.