| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search string with condition | Excel Discussion (Misc queries) | |||
| Search for Condition, Text based, Date Range, Occurrences | Excel Worksheet Functions | |||
| search for data matching some condition | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| how to search in excel with condition | Excel Discussion (Misc queries) | |||
Threaded Mode
