Quick CountIfsquery Please


Hoping somebody can make my life easier please.

I'm currently using the following countifs formula:

=COUNTIFS({CoCode}, "114", {Status.}, "Not Started")

What can I change it to so I don't have to manually enter a new co. code(eg 114) and status (eg Not Started) every time? Imagine there is some way I can just tell the formula to include the text inside a certain cell and then drag it down/across etc.

This is what it looks like currently for reference.

Thank you


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would use somethign along the lines of:

    =COUNTIFS({CoCode}, $[Column7]@row, {Status.}, [Column8]$15)

    Just change the 15 after [Column8]$ to whatever row number has that text in it. Then you can dragfill down and to the right.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!