cell with comments

[kiboy^palaboy]

how to create a formula to sum all cells in a column that has c comment,is
that possible?

 

[Jacob Skaria]

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

 

[Dave Peterson]

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]

Thanks Dave, I missed to mention that..