Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Help Needed! - IF rule
Hi,,
I am trying to total a column based on whether a value has been entered (but to ignore the actual value), giving a total of the cells with values in. Something along the lines of IF value greater than 0, to count that as 1..
Help would be greatly appreciated if anybody knows the formula??
Kindest Regards,
Ben
Comments
-
If the cells are originally blank you should be able to do a simple count like this:
=COUNT(ColumnName:ColumnName)
or do the cells have a default value of zero?
-
Hi Ben,
To come up with a count only when the cell has a value greater than 0, and is not blank, please try this forumua:
=COUNTIF([ColumnName]:[ColumnName], ">" + 0)
For example, I used it on "Coumn5" on my sheet, and the foumla calculated the counts as 2 out of 4 rows, becasue it skips counting one row that is blank, and the other row that has 0.
-
Jenny Lam - this is exactly what I was looking for. Thanking you!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives