| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding sum formula answers in select cells
In Excel 2003 I have a simple sum formula that is copied down the column.
When I type in a value, it displays the answer all the way down the column. Is there a way to hide the answer in only the cells that are for rows where no value is typed in? For example: Cell B14 has the value 2 in it, and cells C14 - C29 have the total 2 displayed. I just want the total of 2 displayed in only C14 and hidden from C15 - C29. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS | Excel Discussion (Misc queries) | |||
| Hiding Results of Answers for a Quiz | Excel Discussion (Misc queries) | |||
| Locking some cells and hiding formula | Excel Discussion (Misc queries) | |||
| Can I select hiding a column as a conditional formatting? | Excel Discussion (Misc queries) | |||
| Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Threaded Mode
