Just pointing out that you wrote the wrong range in your formulas.... you
wrote A1:I1 instead of A1:J1.

--
Rick (MVP - Excel)



"JLatham" wrote in message
...
=(SUM(A1:I1)-COUNT(A1:I1))*5
will also give the same result of 60 and it's a simpler formula, so faster
to execute.

"nordiyu" wrote:

Sir,
How to count total point for cell A1 to J1:
A B C D E F G I J
1 4 1 4 3 2 1 1 2 3

if, 1=0 point, 1=5 point, 2=10 point, 4=15 point