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