Home 
Search 
Today's Posts 
#1




How do I prevent incorrect formula results appearing in cell?
Using this formula:
{=SUM(IF(ISTEXT(C5:C86),1,0),IF(ISTEXT(E5:E86),1,0 ),IF(ISTEXT(G5:G86),1,0))}, the formula pallette displays "Formula results = 15". That is the number of Text items I physically counted. However when I select "OK," the number "0" is recorded in the cell instead of "15." I checked the Cell Formatting and it was set to General. I tried "Help" but it was not there or I just didn"t know where to look. Can you help me? 
#2




You need to confirm that formula with control+shift+enter instead of the
usual enter. However, the following just needs enter and less costly qua time: =SUM(COUNTIF(C5:C86,"?*"),COUNTIF(E5:E86,"?*"),COU NTIF(G5:G86,"?*")) Marc Todd wrote: Using this formula: {=SUM(IF(ISTEXT(C5:C86),1,0),IF(ISTEXT(E5:E86),1,0 ),IF(ISTEXT(G5:G86),1,0))}, the formula pallette displays "Formula results = 15". That is the number of Text items I physically counted. However when I select "OK," the number "0" is recorded in the cell instead of "15." I checked the Cell Formatting and it was set to General. I tried "Help" but it was not there or I just didn"t know where to look. Can you help me? 
#3




Hi!
Your formula should work if you did in fact enter it as an array. Type the formula but use the key combo of CTRL,SHIFT,ENTER instead of just ENTER. Some other options: Entered as an array: =SUM(ISTEXT(C5:C10),ISTEXT(E5:E10),ISTEXT(G5:G10)) Entered normally: =SUMPRODUCT((ISTEXT(C5:C10)+ISTEXT(E5:E10)+ISTEXT (G5:G10))) Biff Original Message Using this formula: {=SUM(IF(ISTEXT(C5:C86),1,0),IF(ISTEXT(E5:E86),1, 0),IF (ISTEXT(G5:G86),1,0))}, the formula pallette displays "Formula results = 15". That is the number of Text items I physically counted. However when I select "OK," the number "0" is recorded in the cell instead of "15." I checked the Cell Formatting and it was set to General. I tried "Help" but it was not there or I just didn"t know where to look. Can you help me? . 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Cell shows formula and not the result of the formula.  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)  
GET.CELL  Excel Worksheet Functions  
can i colour a cell on basis of results of a formula e.g clour bl.  Excel Worksheet Functions 