using sum(collect()) with an or in the criterion range

Sheet A has three contact columns per row.

Sheet B has a list of personnel.

I'd like to collect the rows where a person appears in any of the three contact columns from Sheet A and sum on a numeric column

My current solution is to write three sum(collects()) - one matching each contact column - and add the result.

Is there a way to incorporate an or() into the criterion_range to simplify this?

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Tim Machula

Hope you are fine, did you mean that in your sheet B for each contact in sheet A you count how many time this contact X repeated in each of the 3 contact columns?

Bassam Khalil

Hi @Tim Machula

Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

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.