Arriving at totals

[msnarayanan]

dear all
I have a table with 5 columns/5 rows
(25 cells). Each cell have some numbers.
How to find out the total.

7. 1. 5. 3. 2
8. 4. 9. 5. 5
6. 7. 2. 8. 1
4. 8. 4. 1. 3
,2. 9. 2. 6. 1
Total should be 113

Is there a formula for this.

Thanks
m s narayanan

 

[FryGirl]

It appears there is a dot behind each number, and if so, try...

=SUMPRODUCT(--(SUBSTITUTE(A1:E5,".","")))

 

[msnarayanan]

thank you very much.

m s narayanan