In J1, use this formula, then fill down.
=IF(AND(OR(I1="A", I1="B"), K1="C", O1="C"), 1, 0)

Cheers,
Rob


Dancest˜†r wrote:[i]
I'm having a hard time figuring this one out

My challenge is to count if column is "A" or "B" and column [K]
and [O] are "C"


I'm trying to count all the ones in column [J] that meet the specific
conditions.
I tried an array but it didn't seem to take.

Any hints are greatly appreciated.