Multiple Count Ifs

[ithoughtiknewit]

Hello!

I am using a countif to determine if an employee is assigned to something. AC lists the employees and anywhere from A to U is where I am looking for a match. This works great:

=IF(COUNTIF(A:U,AC1)>0,"ASSIGNED","OPEN")

That said, I am now trying to add if they are on PTO also. The PTO list lives in V. I tried:

=IF(COUNTIF(A:U,AC24)>0,"ASSIGNED","OPEN")+IF(COUNTIF(V6:V16,AC24)>0,"PTO","OPEN")

but no luck. Is this possible or should I do something different? Thanks as always!!!

 

[JoeMo]

Both parts of your second formula: [=IF(COUNTIF(A:U,AC24)>0,"ASSIGNED","OPEN")+IF(COUNTIF(V6:V16,AC24)>0,"PTO","OPEN")] return text values. You can't add text values.

I'm not sure what result you expect, but you can get a text result if you replace the + sign with an ampersand (&) like this:
=IF(COUNTIF(A:U,AC24)>0,"ASSIGNED","OPEN")&IF(COUNTIF(V6:V16,AC24)>0,"PTO","OPEN")

 

[ithoughtiknewit]

Both parts of your second formula: [=IF(COUNTIF(A:U,AC24)>0,"ASSIGNED","OPEN")+IF(COUNTIF(V6:V16,AC24)>0,"PTO","OPEN")] return text values. You can't add text values.

I'm not sure what result you expect, but you can get a text result if you replace the + sign with an ampersand (&) like this:
=IF(COUNTIF(A:U,AC24)>0,"ASSIGNED","OPEN")&IF(COUNTIF(V6:V16,AC24)>0,"PTO","OPEN")

That did it, thank you!!

 

[JoeMo]

That did it, thank you!!

You are welcome - thanks for the reply.