Calculate total based on cell values.

Hi all,

I'm trying to put to gether a calculator for a medical outcome measure called the SPADI.

It has 5 questions, rated 1-10 (total possible = 50) and needs to be calculated as:

Total PAIN score: Value obtained / 50 x 100 = %

If someone misses a question, we must drop the total possible to 40.

I tried using sumif but this didn't quite work :

=SUMIF(D8:H8, ">=0", D8:H8) This only gives me the total. Still checking the helpfiles to see if there's a function I've missed!

Thanks,

Adam

Excellent, thank you! Just had to tweak it to :

=SUM(D6:H6)/(COUNTIF(D6:H6,">=0")*10)*100

otherwise didn't give me the value I was expecting.