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 information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
Awesome! Worked!
Thank-you
-
No problem! π
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!