How to count values if either of two conditions are true

Arundhati

I have two sheets: Sheet A and Sheet B

I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver".

Both sheets are stored under the same folder.

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

TVang

Hi, @Arundhati , the formula below will achieve that.

=COUNTIF({Sheet A Column A}, "Liver") + COUNTIF({Sheet B Column B}, "Liver")

...where {Sheet A Column A} and {Sheet B Column B} are cross-sheet references to the corresponding columns in each sheet.

Arundhati

Thanks Toufong, maybe the formula needs a little more detail. That one is not returning results.

Here is what I am trying: =COUNTIF(OR(CONTAINS("Liver", {SheetA Range1}), CONTAINS("Liver", {SheetB Range2})), "Liver")

This formula is in a third sheet that is performing similar countif functions for other values.

Arundhati

Simplifying the formula has worked as always. I asked the formula to sum two countif statements and it worked :D

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.