If I have a long series of numbers in a column, I want each number (whether
it is between 2 and 9) to represent the number 1, regardless of its size.
This is so that I know how many guests I have invited; however, their
responses correspond to certain codes (i.e. 2 = refused, 3 = interested etc)
for which I have used the COUNTIF formula. Obviously adding up the contents
of the column suggests that I have invited far more people than I had! Hope
that this makes sense.