Formula needed for counting text
Nathan Winegar
✭✭✭
Attached is a sample screen shot of 6 names. On the seventh cell, what formula do I input so it reads "6"? I need a way to sum up all of the names in a column.
Comments
-
You can use something like this:
=COUNTIF(Range:Range, NOT(ISBLANK(@cell)))
-
or just =
count(Name1:Name6)
would work.
-
I would have to agree with L@123's solution for this one. If you are referencing the entire column, you will get a #CIRCULAR REFERENCE error since the formula is within the range.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives