How to get Countif with Discontinous Cells in a row?

Robert Gallegos

=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...

Robert Gallegos

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, "")))))

Genevieve P.

Hi @Robert Gallegos

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

Robert Gallegos

Awesome! Worked!

Thank-you

Genevieve P.

No problem! 🙂