I'm trying to count a group of people in column 1 and 2, but I don't want to double count them.


For example, I want to count David on Column 1 or 2, but if David is on both columns 1 and 2, I don't want it to count David twice only once. How do I do that? I've used the formula below but it counted 141 instead of 101. Not sure what I am missing but I'd appreciate your help!

COUNTIFS({LCS}, OR(@cell = "name", @cell = "name", @cell = "name", @cell = "name", @cell = "name"), {LCO}, OR(@cell <> "name", @cell <> "name", @cell <> "name", @cell <> "name", @cell <> "name", ISBLANK(@cell))) + COUNTIF({LCO}, OR(@cell = "name", @cell = "name", @cell = "name", @cell = "name", @cell = "name"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!