How to get Countif with Discontinous Cells in a row?
=COUNTIF([Part # 1]@row, [Part # 3]@row, [Part # 5]@row, <>""))
Isn't working - results in error # Argument
Trying to count each cell if not blank...
Answers
-
I figured it out using nested IF:
=IF([Part # 5]@row <> "", 5, IF([Part # 4]1 <> "", 4, IF([Part # 3]1 <> "", 3, IF([Part # 2]1 <> "", 2, IF([Part # 1]1 <> "", 1, "")))))
-
I'm glad you got it working!
Is there any possibility that Part 1 or Part 2 might be blank, but Part 5 won't be? In this instance, your current Nested IF formula will return "5" because it's only looking at the Part 5 cell.
If you're looking for a Count across all Parts, regardless of order, you could use a COUNT function similar to what you had above. COUNT will automatically only count cells that aren't blank.
Try:
=COUNT([Part # 1]@row, [Part # 2]@row, [Part # 3]@row, [Part # 4]@row, [Part # 5]@row)
Cheers,
Genevieve
-
Awesome! Worked!
Thank-you
-
No problem! 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!