COUNTIF with or + and variables
---If you are looking to have the count as 1 for each row in Col J then try
the below in cell J1 and copy down
=IF(AND(OR(I1="A",I1="B"),K1="C",O1="C"),1,0)
---If you want the sum of the count you can use the below formula which will
get the count for the rows 1 to 100
=SUMPRODUCT((I1:I100={"A","B"})*(K1:K100="C")*(O1: O100="C"))
--
Jacob
"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.
.
|