COUNTIFS with AND/OR

deb_63_hydracor

Hi,

I'm trying to count the number of sites that have PNS and are either Experiencia, Experiencia Plus or Experiencia Plus Unlimited.

This formula is giving me an UNPARSEABLE error.

=COUNTIFS(OR({Experiencia Tier}, "Experiencia",{Experiencia Tier}, "Experiencia Plus",{Experiencia Tier},"Experiencia Plus Unlimited"), {PNS}, 1))

Thank you!

Samuel Mueller

@deb_63_hydracor try the following

=COUNTIFS({Experiencia Tier}, OR(@cell = "Experiencia",@cell = "Experiencia Plus",@cell = "Experiencia Plus Unlimited"), {PNS}, 1)

Samuel Mueller

@deb_63_hydracor try the following

=COUNTIFS({Experiencia Tier}, OR(@cell = "Experiencia",@cell = "Experiencia Plus",@cell = "Experiencia Plus Unlimited"), {PNS}, 1)

Leibel S

@deb_63_hydracor

Below is how you would use the OR function:

=COUNTIFS({PNS}, 1,{Experiencia Tier}, OR(@cell="Experiencia",@cell= "Experiencia Plus", @cell=,"Experiencia Plus Unlimited"))

Another option here may be, if the word Experiencia is only found in the 3 options listed you can simplify to:

=COUNTIFS({PNS}, 1,{Experiencia Tier}, CONTAINS("Experiencia",@cell))

deb_63_hydracor

Thank you both. That worked!