Google Spreadsheet Post #1220
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).
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).
How could i edit the formula so that it simply ignores the blank cells and the out (in column F) should be for the actual data and not for the blank cells?
Thanks!
------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment