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