| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing cell value makes the formula plain text
I have a working formula:
=COUNTIFS(E3:E74,"In Progress",F4:F74,A97)+COUNTIFS(E4:E74,"Not Done",F4:F74,A97) BUT when I change something like E3, to E4, the formula appears simply as plain text. Any ideas? Stergios |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks in plain text? | Excel Discussion (Misc queries) | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| hyperlinks and plain text in same cell? | Excel Discussion (Misc queries) | |||
| How do I create a formula that makes text in a cell = 0 | Excel Worksheet Functions | |||
| Hyperlink from plain text. | Excel Discussion (Misc queries) | |||
Threaded Mode
