Wednesday, June 28, 2017

yogi_Row By Row Sum Of Specified Number Of Non-Zero Entries

Google Spreadsheet   Post  #2195
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-28-2017
question by advantagepro:
https://productforums.google.com/forum/#!topic/docs/UpsF7OTdCKs;context-place=forum/docs
SUM of values from first four columns that contain a value

I want to create a formula that will add up the values from the first 4 columns in a row that contain a value. I created this sheet to demonstrate the values I would want it to return.