COUNTIF with or + and variables
or to put it all in one formula:
=SUMPRODUCT((I1:I100="A")+( I1:I100="B"), --(K1:K100="C"), --(O1:O100="C"))
--
David Biddulph
"Rob van Gelder" wrote in message
...[i]
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'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.
|