Countifs Function Not working


So, I've been working on this for a day. I have a headache lol. Can someone take a look at this formula and make suggestion as to what I'm missing?

=COUNTIFS({Staff}, "Name", ({Event Type}, "Sale")

I'm using 2 columns of data and want to do a count using Name and type of sale condition. Suggestion?


  • Genevieve P.

    Hi Elizabeth,

    It looks like you might just have an extra parenthesis in there... try this:

    =COUNTIFS({Staff}, "Name", {Event Type}, "Sale")

    If this doesn't work, it would be helpful to see a screen capture of the sheet you're referencing (but please block out any sensitive data).



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!