Excel is very useful application for people who work in accounting, business, and many similar field with those. After we learn about COUNTIF in other post, count a number of same name in group data, make a drop down menu, now we will learn about COUNTA.
COUNTA is a function in Excel that used ti count a number of contain cell (text or number). The formula is like below :
=COUNTA(value 1)
value 1 shows a range of data that we will count the contain cell. First, we write the formula in Excel =COUNTA("range data") -> example =COUNTA(F5:F10).
In that function, COUNTA -> count a number of contain cell, (F5:F10) -> from coloumn F and row 5 to coloumn F row 10.
That all that infositeplus.blogspot.com can share, hope this article useful for many people.
No comments:
Post a Comment