Using more than symbol

ShaunW

Hi,

i have a drop down that i use as below:

One Country

> One Country

One Region

> One Region

Global

my issue is that when i create a countifs statement - =COUNTIFS({9.Countries or Regions Impacted}, "> One Country") smartsheets adds anything together that starts "One....." so instead of counting just cells that have "> One Country" where i should see 3 i now see 39, any suggestions?

Ray Lindstrom

Hi @ShaunW

Your range is good, but criterion is not quite right.

Try this:

=COUNTIFS({9.Countries or Regions Impacted}, @cell = "> One Country")

And by the way, because you only have one criteria you can use a countif instead of a countifs.

Hope that helps!

BRgds,

-Ray

Ray Lindstrom

Hi @ShaunW

Your range is good, but criterion is not quite right.

Try this:

=COUNTIFS({9.Countries or Regions Impacted}, @cell = "> One Country")

And by the way, because you only have one criteria you can use a countif instead of a countifs.

Hope that helps!

BRgds,

-Ray

ShaunW

Ray,

Many thanks that worked, sometimes you just get formula fog and just can't see the obvious 😁

Cheers

Shaun

Ray Lindstrom

Shaun,

Glad it worked, and you're right about the formula fog. The struggle is real! Everything starts looking the same.