COUNTIFS with criteria from 2 columns and 'not blank'

Hi community

I'm trying to code to get a number of entries that meet criteria from 2 columsn, with one being a specific wording and the other being not blank.

I'm using this formula:

=COUNTIFS(Region:Region, "Perth/South West/Wheatbelt"), [Dietary Requirements]:[Dietary Requirements], NOT(ISBLANK(@cell)))

And it is returning unparseable. I can split the parts and use each side of the function independently with success, but can't seem to combine. Pls help :)

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    You have a parenthesis closing the COUNTIFS after Wheatbelt (probably left over from when you split the formula up). Try removing it.

    =COUNTIFS(Region:Region, "Perth/South West/Wheatbelt", [Dietary Requirements]:[Dietary Requirements], NOT(ISBLANK(@cell)))

  • KPH
    KPH ✭✭✭✭✭✭

    Thank you for the ❤️

    If you can, please mark the question as answered so others know you’re problem is solved.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!