I am using the formula below to count the number of rows where the "Rounding Tracker Range 2" column equals 1 and the "Rounding Tracker Range 4" column equals "Cindy". But it returns #unparseable. What am I doing incorrectly?
=COUNTIFS([Rounding Tracker Range 2]:[Rounding Tracker Range 2], 1, [Rounding Tracker Range 4]:[Rounding Tracker Range 4], "Cindy")
Thank you!