Using more than symbol


i have a drop down that i use as below:

One Country

> One Country

One Region

> One Region


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?

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 07/04/23 Answer ✓

    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!