I have been trying for an hour to figure out how to get a formula that counts only if the cell contains a number. I don't want it to count a cell if it contains text or a formula. If it counts a cell that contains text, it counts a descriptive header that I don't need want counted. If it counts a cell that contains a formula, it double counts something. Is it possible to do this? If needed I can post the many, many failed formulae that I have tried to make this work.
As you can see, I only want to count the people that have a positive number in column C. If I count C7 I count Joey Joe Joe twice. If I count C1, I count something that I don't want counted!
Thanks in advance.
Bookmarks