View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default Two Condition - search

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"