Maybe something like this
Assuming data in A2:A10 (including "No"'s)
where each "No" = to deduct 5 marks, say
In B2: =SUM(A2:A10)-(COUNTIF(A2:A10,"No")*5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Shevy" wrote:
I have a worksheet in which I want to be able to give the NO's in the drop
down a different value so that the total value when added up will tell me the
number of guided learning hours required for the individual.

I hope this makes sense..