| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display answer only in another cell of one containing a formula
I have a a cell containing a formula to display a total time.
e.g. A1 contains =SUMIF($E$5:$E$25,$E28,$D$5:$D$25). This is my actual formula. The answer it gives is 01:00 in time format. Is it possible to display the answer to the formula in cell B1 but not to contain the formula. B1 needs to change as A1 does. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Threaded Mode
