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
Check out the Formula Handbook template!