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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives