COUNTIFS counting mismatch

Hi folks,

Any help appreciated with this...I have some miscounting and can't seem to work it out...arrrgh!

If I filter my main sheet as follows:

The result is a count of 16, which is correct.

However, my formula to achieve the same on a summary sheet I have gives 17?

=COUNTIFS({Business Area}, "Product Group", {Agreement Status}, OR(@cell <> "", @cell <> "Ended", @cell <> "Not Renewed", @cell <> "Terminated"), {Num of Ancestors}, 0)

Probably me being really daft, but anyone have any ideas why!?!

{Num of Ancestors} is a helper column for other calculations I have.

Thank you!

Del

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try changing the OR to an AND.

All comments

Paul Newcome

Try changing the OR to an AND.

Del Horne

Ohhh come on! Seriously?! 🤣😱

Paul Newcome

Haha. Coffee break in order?

Del Horne

Might have to just mainline the caffeine...

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.