Lookup a row and count all the "Yes" values across multiple columns

I can do both of these functions separately without issue, but am struggling to combine them.

I have 2 sheets and would like to lookup a value from the 1st sheet on the 2nd sheet, and then return all the "yes" fields on that row from a set of 8 columns.

I can use match to lookup the value from the 1st sheet and find it in the 2nd sheet.

I can use countif to return how many "yes" values there are across the 8 columns for a specific row.

But how can i combine match with countif? I keep getting incorrect argument.

Any thoughts on this?

Thanks.

Find more posts tagged with

Accepted answers

All comments

KPH

Hi @jimmbo

Can you add a column to the second sheet and put the COUNTIF in there and then return the value of that column in an INDEX MATCH, matching on the lookup value?

jimmbo

I could certainly do that if necessary, but I was hopeful to do it within 1 function and not require the additional column.

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.