Column Names not being recognized in formulas

CLBai

Hi, I'm running into a problem with the column names not being recognized when typing in a formula. I am trying to count the number of users with access using the "yes" symbol and "Active" status using the following formula:

=COUNTIF([User Access]:[User Access], "yes", [Status:Status], "Active")

This formula should work but I keep getting an UNPARSABLE error and I noticed that when I type in the formula, it's not recognizing the column names and turning blue like it usually does. Any idea what could be wrong?

Thanks!

Paul Newcome

Try removing the square brackets from around Status:Status. You are also going to need to use a COUNTIFS with the "S" on the end to be able to include multiple range/criteria sets.

CLBai

I did that and it did not work, but then I renamed the column with just a single name and adjusted the formula to use only a single name and now it works.