How to calculate total score from the given table

[thakur]

Hi,

How to calculate total score from the given table. Attaching the excel sheet. Please advise.

Regards,
Thakur

 

[Luke M]

If the numbers were text, could simply do:
=SUM(D9:D1470)

But, taking what we have, we will need to force the text to become a number through multiplication
=SUMPRODUCT(1*D9:D1470)

 

[thakur]

Hi Luke M,

Can you explain this formula and why are we multiplying it with one.

Regards,
Thakur

 

[Khalid NGO]

Hi Thakur,

Multiply by 1 will convert your text into numbers (your numbers stored as Text).

Alternately you can use simple formula =SUM(D9:D1470)
Just select your range, Go to Data > Text to Columns > Next > Next > Finish