How are count Counta and Countif functions different from each other?
Difference between Count(),Counta(), Countif() are as follows-
S.no | Count() | Counta() | Countif() |
---|---|---|---|
1. | Count() counts only those cells containing numbers | Counta () is a function which counts all the numbers which are not empty | Countif () function is used when counting specified cells meeting certain conditions. |
BY Best Interview Question ON 01 Apr 2019