Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell with comments
how to create a formula to sum all cells in a column that has c comment,is
that possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell with comments
You will have to use a UDF. Try the below. If you are new to macros set the
Security level to low/medium in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below code. Save. Get back to Workbook. To use it in cell; try the below formula =sumcomment(D9:F13) Function SumComment(varRange As Range) SumComment = 0 For Each varCell In varRange If Not varCell.Comment Is Nothing Then SumComment = SumComment + varCell End If Next End Function If this post helps click Yes --------------- Jacob Skaria "kiboy^palaboy" wrote: how to create a formula to sum all cells in a column that has c comment,is that possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell with comments
This function won't recalculate when a comment is added or removed.
It's probably a good idea to make it volatile--and even then, it may be not return accurate results without forcing a recalculation. Jacob Skaria wrote: You will have to use a UDF. Try the below. If you are new to macros set the Security level to low/medium in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below code. Save. Get back to Workbook. To use it in cell; try the below formula =sumcomment(D9:F13) Function SumComment(varRange As Range) SumComment = 0 For Each varCell In varRange If Not varCell.Comment Is Nothing Then SumComment = SumComment + varCell End If Next End Function If this post helps click Yes --------------- Jacob Skaria "kiboy^palaboy" wrote: how to create a formula to sum all cells in a column that has c comment,is that possible? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell with comments
Thanks Dave, I missed to mention that..
-- If this post helps click Yes --------------- Jacob Skaria "Dave Peterson" wrote: This function won't recalculate when a comment is added or removed. It's probably a good idea to make it volatile--and even then, it may be not return accurate results without forcing a recalculation. Jacob Skaria wrote: You will have to use a UDF. Try the below. If you are new to macros set the Security level to low/medium in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the below code. Save. Get back to Workbook. To use it in cell; try the below formula =sumcomment(D9:F13) Function SumComment(varRange As Range) SumComment = 0 For Each varCell In varRange If Not varCell.Comment Is Nothing Then SumComment = SumComment + varCell End If Next End Function If this post helps click Yes --------------- Jacob Skaria "kiboy^palaboy" wrote: how to create a formula to sum all cells in a column that has c comment,is that possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell comments | Excel Discussion (Misc queries) | |||
Cell Comments | Excel Worksheet Functions | |||
Comments into a cell without VB. | Excel Discussion (Misc queries) | |||
print comments using cell contents, not cell# | Excel Discussion (Misc queries) | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) |