Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 30, 2013
user rajvivek (http://productforums.google.com/forum/?zx=7m7yxfezh113#!category-topic/docs/spreadsheets/5k-NERoJugo)
How to let the formula ignore the blank cells?
The formula at this spreadsheet (in cell D3) is taking into consideration all cells including the blank cells, and giving result a part of which is undesirable (as shown in cell F10).