With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, February 16, 2018
yogi_Troubleshoot And Fix Formula Using SUM Function For Entries in E2:E22
question by: Graystrickland https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/pnhEECod1w0;context-place=mydiscussions =Sum() won't sum, but adding same cells (=a1+a2...) works?!?
I have a sheet where the sum function always returns 0, but if I write a manual formula simply adding the same cells (=a1+a2... etc.) then the function produces the correct answer. This means that the source data is *NOT* formatted as plain text. And I've selected all the source cells and made sure they are, in fact, formatted as numbers. Still the =Sum() function does not work. I am stumped. The only reason that I can imagine Sum() not working is when the source data is formatted as plain text, but that's not the case. here.