COUNTIF with or + and variables
Try this€¦
=COUNTIF(I:I,"A")+COUNTIF(I:I,"B")+COUNTIF(K:K,"C" )+COUNTIF(O:O,"C")
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"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.
.
|