L
linda
I am trying to pull value when two conditions are met.
want to count column "B" when it = "ETARC" and when column "J" is = "0" or a
negative number.
I have tried =COUNTIF(B11:B26,"=ETARC")+COUNTIF(J8:J24,""<>0)
the formula is only pulling the column "B" infor and the same number for
column "J". My answer should be 6 for column "B" and 2 for column "J",
instead I am getting the same 6 for the entire data reading only column "B"
want to count column "B" when it = "ETARC" and when column "J" is = "0" or a
negative number.
I have tried =COUNTIF(B11:B26,"=ETARC")+COUNTIF(J8:J24,""<>0)
the formula is only pulling the column "B" infor and the same number for
column "J". My answer should be 6 for column "B" and 2 for column "J",
instead I am getting the same 6 for the entire data reading only column "B"