| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "go to" "blanks" after using a formula | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
