Saturday, December 26, 2015

yogi_Find Row By Row Product Of Set Of Numeric Entries (and the sum of all products) In Range A2:A

Google Spreadsheet   Post  #1996
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26-2015
post by  Jens Ole:
https://productforums.google.com/forum/#!topic/docs/ZyHdFKb4hTI;context-place=forum/docs
Doing calculations without the equals sign
I want the sum of the items, but so far the only way i've found to do that is to write =3*56, =60*23, =12*6 in the cells and then doing a =sum() function.

That works, but the fact that i have to enter the = every time disrupts my workflow a lot.

Is there a workaround?, a way to format the cells so they automatically do their calculations?

Thanks in advance

Jens-Ole
-----------------------------------------------------------------------------------------------------------------------------------