Another excel query
 

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.

Another excel query
 

Look up the COUNTA formula in Help. That will count the number of occupied
cells in a range. Post back if you need more. HTH Otto
"MacSeoinin" wrote in message
...
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.