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?