Hello,
Hope my excel tips are helping you out.
Here is Today’s tip for you. Hope this help you.
If ever we want to count the cell in which text or number is
written , then we can use “COUNTA” Command.
What Does It Do ?
This function counts the
number of numeric or text entries in a list. It will ignore blanks.
The =COUNTA() function has been used
because of its ability to count text and numeric entries.
How to use it ?
'=COUNTA(Range1,Range2,Range3...
through to Range30)
For examples please check the below images
Hope the Tip is found interesting to you and the same is clear.
Looking forward for a feedback.
If any of your friend is also interested for the said excel Tips
, then asked them to fill the form by clicking on the below mentioned link:
If you have something that you want to share with the group,
please write to excelms.tips@gmail.com
Thanks & Regards,
CA Mohit Bansal
Excel Enthusiast
+91-9045773456
No comments:
Post a Comment