Blanks ("") by Formula
in [General]
|
Prev: Referring the cell instead of typing the sheet name
Next: Autofill formulas when inserting rows in excel tables
From: Ken on 28 Apr 2010 08:55 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
From: Ken on 28 Apr 2010 09:04 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
From: zvkmpw on 28 Apr 2010 19:48
On Apr 28, 5:55 am, Ken <K...(a)discussions.microsoft.com> 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. |