You don't need to display it as number 1, you can use

=COUNTIF(Range,"Yes")


Regards,

Peo Sjoblom

"PeterHad" wrote:

I Have created a drop down box with Yes,No in it, this will be used multiple
times to collate information, if yes is selected i want it to represent the
number 1 and be diplayed as number 1 in a seperate sheet,this is the same for
"no" i then want to be able to add up the yes's & no's for each queastion
which, so i need to know how i can keep a running total many thanks