COUNTIFS with criteria from 2 columns and 'not blank'

Lily DV

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

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

Thank you for the ❤️

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