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

https://docs.google.com/spreadsheets/d/1U5o_H3eCjjm3BLCyhj2Kv3keRimPwxTVeuTyC84YWWU/edit#gid=0

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.