=COUNTIF

[Colt_Fisher_43]

Hello,

I have a working formula =COUNTIF(E2:H2,"<>Adams")

How would I add another name like "Davis" so it'll work with both names and remove duplicates?

Thank you

 

[Fluff]

How about

=COUNTIFS(E2:H2,"<>Adams",E2:H2,"<>Davis")

 

[Colt_Fisher_43]

How about

=COUNTIFS(E2:H2,"<>Adams",E2:H2,"<>Davis")

Thank you, it worked!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Colt_Fisher_43]

You're welcome & thanks for the feedback.

One other quick question about a issue I ran into. Would I be able to combine these two formulas together? Not sure if it's even doable, if not no problem.

=SUBSTITUTE(TRIM(E2&" "&F2&" "&G2&" "&H2)," ",", ")

and

=COUNTIFS(E2:H2,"<>Adams",E2:H2,"<>Davis")

 

[Fluff]

In what way?

 

[Colt_Fisher_43]

In what way?

Having this formula omit the two names "Adams" and "Davis" in the total for the formula below. I have it where I'm pulling names from those columns, but want to remove those two names if selected in the columns. Sorry if I'm not explaining it clearly.

=SUBSTITUTE(TRIM(E2&" "&F2&" "&G2&" "&H2)," ",", ")

 

[Fluff]

How about

=SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(E2&" "&F2&" "&G2&" "&H2,"Adams",""),"Davis",""))," ",", ")

 

[Colt_Fisher_43]

How about

=SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(E2&" "&F2&" "&G2&" "&H2,"Adams",""),"Davis",""))," ",", ")

YES! It does! Thank you for your time!

Really, really appreciate it.

 

[Fluff]

Glad to help & thanks for the feedback.