COUNTIFS Statement Help

Options
Emily Swartz
Emily Swartz ✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT

=COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test")

Thanks.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    Options

    Hi eswartz,

    You're seeing the error because your 2 ranges are different sizes. The first range is dealing with 49 rows, while the second is looking at the whole column.

    If you change the formula to the following, you'll be good:

    =COUNTIFS(Status:Status, "Green", Product:Product, "Rapid Test")

    · Share on FacebookShare on Twitter
  • Glen Walter Teles
    Glen Walter Teles ✭✭
    Options

    To add to the above

    Or you can keep the same column ranges for both the columns

    =COUNTIFS(Status3:Status51, "Green", Product3:Product51, "Rapid Test")

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!