Is Formula correct?

jcurry

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!

Nic Larsen

The ranges read like cross sheet so the structure is off a little if that's the case - try:

=COUNTIFS({Rounding Tracker Range 2}, 1, {Rounding Tracker Range 4}, "Cindy")

Nic Larsen

The ranges read like cross sheet so the structure is off a little if that's the case - try:

=COUNTIFS({Rounding Tracker Range 2}, 1, {Rounding Tracker Range 4}, "Cindy")

jcurry

Thank you so much!!