You can see from the lack of replies that this is not normally done,
certainly not by a formula. Comments are generally just that - comments about
the data in the cells.

However, I had a go writing a macro. I hope that you don't mind. I've just
got it working (Two comments). Press Alt + F11, Insert, Module and copy the
code into the Module. Close the VB editor and with the Active sheet having
comments Run the macro. Tools, Macro, Select the macro and click Run.

If this is on the lines that you want I'll improve the code, post back when
you have tried it. If there is anything in the cell this will be over
written.

Also you have to run the code each time a comment is updated. It is not a
function.

Best of luck
Peter

"pcor" wrote:

I have a number of comments in some of my cells
Example :Sugar=200
salt=12
candy=400
Is there a way to add up all these number(200+12+400)
and place the number 612 in the cell where the comments are held?
Thanks