Tuesday, October 8, 2013

yogi_Sum Up Numbers In Non-English Languge Where Transliterated Numbers In The Spreadsheet Are Not Recognized

                                          Google Spreadsheet   Post  #1388
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 08, 2013
user: kalyanbdas (http://productforums.google.com/forum/?zx=l16sw6xw51o2#!category-topic/docs/spreadsheets/vg06fBGPPZQ)
how to sum numbers in non english language

I am using transliteration function in Google spreadsheet (in Bengali) language where there is a range of numbers (in Bengali language in the transliterated forms). I wish to sum the numbers in the range. However, I am unable to use to =sum(reference:reference). The function is not working, even though I turn off the transliteration function.

Is there a way out?

Let me know.


Hello Yogi,

Thank you very much for your reply. I have made a copy of the file. 


Please try to find a solution to this. You can ask me any question regarding the language used in the doc. Else, you can use Google translator to understand the letters in the non-english spreadsheet.

Thank you very much in advance.