Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Distinguishing between Cells with Formula vs Cells with Text/Value
I want to be able to distinguish cells having formulas from cells having just
values. In my particular case, the values will all be numeric. Is there an easy way to do that? My goal is to sum all the values in a given column, ignoring any cells containing formulas that may also be in the column. I'd like to avoid using a macro or User defined function. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help: Add cells with certain text + cells that are blank | Excel Worksheet Functions | |||
distinguishing formula cells | Excel Discussion (Misc queries) | |||
Formula to add two cells when one or both cells are text | Excel Worksheet Functions | |||
Delete text in cells but keep formula | Excel Worksheet Functions | |||
Can I create a formula from text in several cells? | Excel Worksheet Functions |