S
Studebaker
Hello,
I have a list of names in two columns - column B lists the Assistants and
column C lists the Managers. I need to count the number of times the name
"adam" does not appear in column b and column c in the same row - in other
words where adam was neither an assistant or a manager.
I thought this formula would work but it doesn't:
=COUNTIF(B3:B9,"<>*adam*")+COUNTIF(C3:C9,"<>*adam*")
In this example below, the answer should be "3". Only 3 times does the name
"adam" not appear in column 1 and 2 in the same row - i.e., in the 2nd, 4th
and 5th row.
column 1 column 2
adam john
john jeff
greg adam
greg jeff
jeff edward
Please help with a formula.
Thank you
I have a list of names in two columns - column B lists the Assistants and
column C lists the Managers. I need to count the number of times the name
"adam" does not appear in column b and column c in the same row - in other
words where adam was neither an assistant or a manager.
I thought this formula would work but it doesn't:
=COUNTIF(B3:B9,"<>*adam*")+COUNTIF(C3:C9,"<>*adam*")
In this example below, the answer should be "3". Only 3 times does the name
"adam" not appear in column 1 and 2 in the same row - i.e., in the 2nd, 4th
and 5th row.
column 1 column 2
adam john
john jeff
greg adam
greg jeff
jeff edward
Please help with a formula.
Thank you