Assuming the question to be in column A and the response in column B then in
C1
=IF(B1="",0,1)
Copy the formula down the cange of column C to match your range of data.
Sum the range of column C,
=SUM(C1:C100) for example

--
Regards
Roger Govier
"joolz46" wrote in message
...
HI,
I have a column with yes/no or blank answers to be reflected in another
column with a 1 for y or n and a blank for a blank answer. I then need a
total for all the 1's in the same column! Sorry if this sounds a bit
gobbledegook. its the best I can do!