Here is another formula for you to try...

=SUMPRODUCT((A1:J1-1)*5)

--
Rick (MVP - Excel)



"nordiyu" wrote in message
...
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