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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Distinguishing between Cells with Formula vs Cells withText/Value
select the column | Ctrl + G | click special | select constants | ok
on stutus bar right click | sum | On Oct 6, 8:29*pm, bstobart wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Distinguishing between Cells with Formula vs Cells with Text/V
Can I do that in a formula directly without the mouse moves?
"muddan madhu" wrote: select the column | Ctrl + G | click special | select constants | ok on stutus bar right click | sum | On Oct 6, 8:29 pm, bstobart wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Distinguishing between Cells with Formula vs Cells with Text/V
Try this UDF ( user defined function)
Function Sumnum(rng As Range) Dim r As Range Dim v For Each r In rng If r.HasFormula = False Then v = WorksheetFunction.Sum(r) + v End If Next r Sumnum = v End Function On Oct 6, 9:02*pm, bstobart wrote: Can I do that in a formula directly without the mouse moves? "muddan madhu" wrote: select the column | Ctrl + G | click special | select constants | ok on stutus bar right click | sum | On Oct 6, 8:29 pm, bstobart wrote: 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.- Hide quoted text - - Show quoted text - |
Reply |
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 |