COUNTIFS counting mismatch

Del Horne

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

Paul Newcome

Try changing the OR to an AND.

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...