Correct Formula to use? COUNTIFS

Good day,

I need to count the number cells that needs to comply to 2 types of criteria. I have a summary sheet that contains certain names, then on another sheet I have the 2 criteria's to be met - one matching the name as on summary sheet and the other criteria being the status on the other sheet.

For Example: On the Summary sheet I have: Apple

On the other sheet I have the same name: Apple,

On the other sheet I have a status: 1.

The formula I needs to be on summary sheet , referencing Apple, and then count on the other sheet how many statuses does Apple have of 1

Pls help

Find more posts tagged with

Accepted answers

Lucas Rayala

https://community.smartsheet.com/discussion/116329/correct-formula-to-use-countifs

Hi Aubrey, assuming that Apple is in a column called Fruit in both sheets, create this formula in your summary sheet:

=COUNTIFS({Fruit}, Fruit@row, {Status}, 1)

Here’s the help sheet on how to use the function:

https://help.smartsheet.com/function/countifs

All comments

Lucas Rayala

https://community.smartsheet.com/discussion/116329/correct-formula-to-use-countifs

Hi Aubrey, assuming that Apple is in a column called Fruit in both sheets, create this formula in your summary sheet:

=COUNTIFS({Fruit}, Fruit@row, {Status}, 1)

Here’s the help sheet on how to use the function:

https://help.smartsheet.com/function/countifs

Aubrey Ferreira

Thank you - appreciate the help

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.