Count Checks on Another Sheet

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.