| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I edit the formula without changing the format? {=SUM(if.
I have this formula in a cell: {=SUM(IF(ISTEXT(C6:Q6),1,0))}
When I press F2 and hit enter excel removes the brakets from the formula and instead of having the sum I got zero as a result. How can I edit the formula without changing the format? When I insert the brackets, excel treats the formula into a text value. Thanks Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| & in formula changing date format to text ? | Excel Worksheet Functions | |||
| Tool bar keeps changing back after I add edit buttons | Excel Discussion (Misc queries) | |||
| how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
| Macro help on changing data in Edit Find Box | Excel Discussion (Misc queries) | |||
| Formula for changing date format | Excel Worksheet Functions | |||
Threaded Mode
