countifs

I have a sheet A with Client name and status, I have a sheet B with the data, I want to search every row of sheet B for the client and status of completed live or completed live missing docs.

=countif({Sheet B Range 1}, [client name]1, (Sheet B Range 2), OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

individually these work together it returns 0

any help would be great

Find more posts tagged with

Accepted answers

Victoria_Indimar

Hello @Gregw . The formula looks good but it should be COUNTIFS since you have two criteria you're matching on. I've bolded the changes below.

=COUNTIFS({Sheet B Range 1}, [client name]@row, {Sheet B Range 2}, OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

Hope this helps!

Paul Newcome

The parenthesis around the second range need to be swapped out with curly brackets to indicate a cross sheet reference.

All comments

Victoria_Indimar

Hello @Gregw . The formula looks good but it should be COUNTIFS since you have two criteria you're matching on. I've bolded the changes below.

=COUNTIFS({Sheet B Range 1}, [client name]@row, {Sheet B Range 2}, OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing Documentation"))

Hope this helps!

Paul Newcome

The parenthesis around the second range need to be swapped out with curly brackets to indicate a cross sheet reference.

Gregw

Thank you so much to both of you!

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