| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf formula results in the formula itself being displayed.
Is it only the COUNTIF formula that shows up as text or does any formula show up as text? If any formula shows up as text than the cell you entered the formula in was probably formatted as text prior to entering it. Delete the COUNTIF formula and check that cell's format. If it is Text then change it to General and re-enter your formula. If it is not text then check under Tools/Options/View Tab to see if in the Window View area the check box next to formulas is selected. If it is, all formulas in your sheet will be visible and not their results. HTH Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=495346 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Function Formula is displayed not results | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| formula displayed instead of the result ??? | Excel Worksheet Functions | |||
| can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions | |||
Threaded Mode
