Answer by
yeswanth (235)
Countif will counts the number of cells in the range of given criteria. The most efficient method is to use pivot table for using countif else use spreadsheet. The syntax is countif(range,criteria). Note that criteria argument is in number. But for more conditions we cannot use countif function in order of their efficiency.
