Blanks ("") by Formula
 

Excel2003 ...

Range (H3:H13) contains Formulas returning a space ("")
Cell H15 contains ... =IF(OR(D1="",COUNTA(H3:H13)=0),"",SUM(H3:H13))

Cell H15 returning correct value when values in Range (H3:H13) manually
entered ... but, now that I have Formulas in this Range returning a space
("") the COUNTA(H3:H13) part of my formula is returning "11" ...
Consequently, the SUM portion of my Formula is returning "0" when I wish
Formula to return a space ("")

What adjustment do I need to make? Thanks ... Kha

Blanks ("") by Formula
 

I have it ... I just needed to remove the "A" & use COUNT ... I tried this
before with no success so I am guessing I fat-fingered something ...

My Thanks to all that provide the many helpful solutions on this board ... Kha

"Ken" wrote:

Excel2003 ...

Range (H3:H13) contains Formulas returning a space ("")
Cell H15 contains ... =IF(OR(D1="",COUNTA(H3:H13)=0),"",SUM(H3:H13))

Cell H15 returning correct value when values in Range (H3:H13) manually
entered ... but, now that I have Formulas in this Range returning a space
("") the COUNTA(H3:H13) part of my formula is returning "11" ...
Consequently, the SUM portion of my Formula is returning "0" when I wish
Formula to return a space ("")

What adjustment do I need to make? Thanks ... Kha

Blanks ("") by Formula
 

On Apr 28, 5:55*am, Ken wrote:
Excel2003 ...

Range (H3:H13) contains Formulas returning a space ("")
Cell H15 contains ... =IF(OR(D1="",COUNTA(H3:H13)=0),"",SUM(H3:H13))

Cell H15 returning correct value when values in Range (H3:H13) manually
entered ... but, now that I have Formulas in this Range returning a space
("") the COUNTA(H3:H13) part of my formula is returning "11" ...
Consequently, the SUM portion of my Formula is returning "0" when I wish
Formula to return a space ("")

What adjustment do I need to make? *Thanks ... Kha

Maybe using COUNT instead of COUNTA would help.