What am i doing wrong?

I am trying to add data form two columns if they contains set information, however i keep getting it wrong?

=COUNTIFS((AND({PTQ-R-021 Actions Log - Corrective/Prevent Range 2}, "Observation"):{PTQ-R-021 Actions Log - Corrective/Prevent Range 1}, "Health & Safety"))

Find more posts tagged with

Accepted answers

All comments

Donrow

=COUNTIFS({PTQ-R-021 Actions Log - Corrective/Prevent Range 2}, "Observation"), : ({PTQ-R-021 Actions Log - Corrective/Prevent Range 1}, "Health & Safety")

Also tried this?

Donrow

=COUNTIFS({PTQ-R-021 Actions Log - Corrective/Prevent Range 2}, "Observation") + =COUNTIFS({PTQ-R-021 Actions Log - Corrective/Prevent Range 1}, "Health & Safety")

And this

Paul Newcome

Your last one is the closest. Try removing the = from before the second COUNTIFS.

Donrow

Its not quite right still

it needs to add items in one column and two column if they have both the varibles?

Donrow

By removing the second = its only giving me the Health & safety totals

It needs to add all health and safety totals if they are Major non-conformity

Paul Newcome

Are you able to provide some screenshots for context?

Donrow

Need to action type "observation" when compliance is "Health and safety"

Paul Newcome

Try combining them into a single COUNTIFS.

Donrow

that will not give me what i am looking for

Donrow

i need to know how many health and safety i have in observation

Paul Newcome

Right. Combining them into a single COUNTIFS will give you what you are looking for.

Donrow

How do i do that?

Paul Newcome

You would follow the standard syntax for a COUNTIFS that allows you to input multiple range/criteria sets within the same function.

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

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.