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!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!