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
|