Excel BI Analytics

Tips & Tricks 16 – Count No. of Cells Having Numbers Only

Posted on by Vijay A. Verma

COUNT function counts only those cells which are having numbers.

Assuming your range is A1:A10, use following formula

=COUNT(A1:A10)

Leave a Reply

Your email address will not be published. Required fields are marked *