Wednesday, December 16, 2015

yogi_Compute Row By Row Sum Of Entries In Columns B Through F For Condition Spelled Out In Cell G1

Google Spreadsheet   Post  #1991
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-16-2015
post by  bbiagllla:
https://productforums.google.com/forum/#!topic/docs/-RQ225qEEyg;context-place=mydiscussions
Working with If(and(or at the same time kind of
Ok i need to add up multiple columns based on criteria. Basically i need to take 5 columns and give and if statement to add a number if 2 of them are over 9 and/or 3 of them are over 9. I will attach a link


in this sheet i need the following to happen



=B2+(C2*1.5)+(D2*1.25)+(E2*2)+(F2*2)+or(if(or(and(B2,C2),and(B2,D2),and(B2,E2),and(B2,F2),and(C2,D2),and(C2,E2),and(C2,F2),and(D2,E2),and(D2,F2))>9,2,0),if(or(and(B2,C2,D2),and(B2,D2,E2),and(B2,E2,F2),and(B2,C2,E2),and(B2,C2,F2),and(C2,D2,E2),and(C2,E2,F2),and(D2,E2,F2))>9,3,0))


Edited
---------------------------------------------------------------------------------------------------------------------------------------