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.
    Genevieve P. Employee Admin

    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).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!