Count Checks on Another Sheet

Judith Campf

I need a formula that matches a user's name on the first sheet and goes to a second sheet to find that same user's name and counts how many times that user has a checkbox checked off.

I tried something like this but am getting #NO MATCH as a result.

=INDEX(({Target Sheet with Username Column Selected}), MATCH([Username Column]@row, COUNT({Target Sheet with Checkbox Column}, 1)))

Any thoughts on why this won't work if the checkbox is checked?

Judy

Paul Newcome

Try using a COUNTIFS instead.

Judith Campf

I replaced "COUNT" with "COUNTIFS" and "COUNTIF" and neither produced the number.

Paul Newcome

Can you paste in the COUNTIFS that you used?

Judith Campf

=INDEX(({Live Lesson Reviews (Quality Assurance) Range TN}), MATCH([Active Teachers]@row, COUNTIF({Live Lesson Reviews (Quality Assurance) Range SE}, 1)))

Live Lesson Reviews (Quality Assurance) Range TN = Name of column on other sheet looking at the Teacher's Name

Active Teachers = Teacher's Name on the sheet where I want the count to appear

Live Lesson Reviews (Quality Assurance) Range SE = Name of column on the other sheet looking at the checkbox for Sent Email

Paul Newcome

You would have to use a standalone COUNTIFS. Not have it nested inside of another function.

Genevieve P.

Hi @Judith Campf

Here's an example of what @Paul Newcome means, if it helps!

=COUNTIFS({Teacher Column}, [Active Teachers]@row, {Checkbox Column}, 1)

Cheers,

Genevieve