I have a worksheet where in column H the user enters a District number. District numbers are 1 to 16. Occasionally, there can be more than one district number entered into the same cell. On the "Stats" worksheet there is a total count of how many times each of the District numbers appear in column H.
For the "Stats" worksheet is there a formula that will count each district number and not count each number separately in any of the numbers 10 through 16? I have tried a couple of formulas I found in a search on the web but the formulas will count 1, 4, and 14 when the number 14 is the only number entered into the cell.
Thank you for your response.
Bookmarks