Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My results don't appear in the cell
I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct
because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#2
|
|||
|
|||
So what *does* appear in the cell?
-- Kind Regards, Niek Otten Microsoft MVP - Excel "DeltaSis4" wrote in message ... I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#3
|
|||
|
|||
Nothing
"Niek Otten" wrote: So what *does* appear in the cell? -- Kind Regards, Niek Otten Microsoft MVP - Excel "DeltaSis4" wrote in message ... I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#4
|
|||
|
|||
As you can tell there aren't many mindreaders here.
But we're getting better at pulling teeth. What is the formula and what are the values it is looking at. Provide information so that a question can be answered. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DeltaSis4" wrote in message ... Nothing "Niek Otten" wrote: So what *does* appear in the cell? -- Kind Regards, Niek Otten Microsoft MVP - Excel "DeltaSis4" wrote in message ... I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#5
|
|||
|
|||
=(SUM(IF(ISTEXT(C6:AE6),0.5,0)))
"David McRitchie" wrote: As you can tell there aren't many mindreaders here. But we're getting better at pulling teeth. What is the formula and what are the values it is looking at. Provide information so that a question can be answered. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DeltaSis4" wrote in message ... Nothing "Niek Otten" wrote: So what *does* appear in the cell? -- Kind Regards, Niek Otten Microsoft MVP - Excel "DeltaSis4" wrote in message ... I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#6
|
|||
|
|||
You can't have a range of more than once cell for ISTEXT.
even if you had all text values in every cell you would get False Value is the value you want tested. Value can be a blank (empty cell), error, logical, text, number, or reference value, or a name referring to any of these, that you want to test. =IF(ISTEXT(C6:AE6),0.5,0) ISTEXT will alwasys be false so you get 0 from that. So surround that with sum simply gets 0. That was more fun than pulling teeth. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DeltaSis4" wrote in message ... =(SUM(IF(ISTEXT(C6:AE6),0.5,0))) "David McRitchie" wrote: As you can tell there aren't many mindreaders here. But we're getting better at pulling teeth. What is the formula and what are the values it is looking at. Provide information so that a question can be answered. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DeltaSis4" wrote in message ... Nothing "Niek Otten" wrote: So what *does* appear in the cell? -- Kind Regards, Niek Otten Microsoft MVP - Excel "DeltaSis4" wrote in message ... I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!! |
#7
|
|||
|
|||
I'm not sure if the expression
=SUM(IF(ISTEXT(C6:AE6),0.5,0)) was meant to be array-entered (Press CTRL+SHIFT+ENTER) which then seems to work as intended ?? That was more fun than pulling teeth. ROTFL! I've got only a set of dentures, btw. No need to pull, just take out / wash / put back. <bg -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#8
|
|||
|
|||
Thank you Max!! That worked. The spreadsheet was a template the worked
before I started adding columns. I will remember this trick for the future!! "Max" wrote: I'm not sure if the expression =SUM(IF(ISTEXT(C6:AE6),0.5,0)) was meant to be array-entered (Press CTRL+SHIFT+ENTER) which then seems to work as intended ?? That was more fun than pulling teeth. ROTFL! I've got only a set of dentures, btw. No need to pull, just take out / wash / put back. <bg -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#9
|
|||
|
|||
You're welcome !
Glad it worked for you .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "DeltaSis4" wrote in message ... Thank you Max!! That worked. The spreadsheet was a template the worked before I started adding columns. I will remember this trick for the future!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
VLOOKUP - results do not appear in cell | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |