top of page
  • Writer's pictureDp

COUNTA function in Excel

Updated: May 2, 2019

This function counts the number of numeric or text entries in a list. It will ignore only blanks.


=COUNTA(Range1,Range2,Range3... through to Range30)


Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at


Recent Posts

See All


bottom of page