Tuesday, January 7, 2014

yogi_Count 1 For Every Instance Of A Name In Column A and 1/2 For Every Instance Of A Name In Columns A And B For A Specified Model

                                          Google Spreadsheet   Post  #1476
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-07-2014
question by Lance Williams (http://productforums.google.com/forum/?zx=ip34bhygdoid#!category-topic/docs/spreadsheets/0qcUv1z-Q2s)
Google spreadsheet counting formula


I need a formula that will count a full unit when there is an entry in Name1 and a half unit when there is an entry in Name1 and Name2.  For example, calculate:
- How many units does EC get credit for on Model 9700?  The answer would be 2.5 (line 5 = .5, line 7 = 1, line 8 = .5, line 9 = .5)
--------------------------------------------------------------------------------------------------------------