Trying to help a friend with a really simple
COUNITF/COUNTIFS formula. Data is like:
Objective is to count the data cells excluding mike, john, judy. Current formula:
which returns the correct value 3. Problem is that he has much more than three names to exclude. We would like to list them in column B and have the formula refer to the list (otherwise the formula becomes huge). We have tried:
both normal-entered and array-entered, but it yields 12 !
Strangely enough, if we want to include rather than exclude then :
works. I offered a VBA solution, but that was rejected.