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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Awesome! Worked!
Thank-you
-
No problem! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!