Countifs Question

HI I am trying to do a Countifs using the below, the result keeps coming back as 0 but I think that is because the box only has either Pass or Fail in it but not both in the same cell, I am trying to add up all Pass and Fail Inspections, how do I include both Pass and Fail results.

=COUNTIFS([Building Unit]:[Building Unit], "Stamullen U6", [First Aid Box Adequately Stocked]:[First Aid Box Adequately Stocked], "Pass", [First Aid Box Adequately Stocked]:[First Aid Box Adequately Stocked], "Fail", Month:Month, "1")

thanks

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Olivia Brady

Hope you are fine, please try the following formula:

=COUNTIFS([Building Unit]:[Building Unit], @cell = "Stamullen U6", Month:Month, @cell = 1,
[First Aid Box Adequately Stocked]:[First Aid Box Adequately Stocked], OR(@cell = "Pass",
 @cell = "Fail"))

the following screenshot shows the result:

Olivia Brady

Many thanks that worked :)

All comments

Bassam Khalil

Hi @Olivia Brady

Hope you are fine, please try the following formula:

=COUNTIFS([Building Unit]:[Building Unit], @cell = "Stamullen U6", Month:Month, @cell = 1,
[First Aid Box Adequately Stocked]:[First Aid Box Adequately Stocked], OR(@cell = "Pass",
 @cell = "Fail"))

the following screenshot shows the result:

Olivia Brady

Many thanks that worked :)

Bassam Khalil

@Olivia Brady

Excellent, i will be happy to help you any time.

Olivia Brady

Many thanks, sorry just one more thing on this formula, if I wanted to do this lookup but put the results on a different smartsheet for Countifs referencing this smartsheet how would the formula look

thanks again

Bassam Khalil

@Olivia Brady

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Olivia Brady

many thanks I was trying to share the sheets with you, but getting the below message

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.