Hello All,
I would like to sum a range of cells in a column that have specific text in the comments and display the sum at the bottom of each column. I have multiple columns i would like to add up. Is this possible using text in comments?
I have attached an example of what I would like to happen. I would like to sum all of the cells in a column with the letter "M" in the comments and place the sum at the bottom of each column as shown. I have looked at some VBA posts but they either add all the comments on the whole worksheet or find a specific text in a comment.

The other option would be to sum numbers found in the comments of a cell and display this at the bottom of each column.
Thanks for any advice,
Phil

Hi Phillip,

Am Thu, 22 Sep 2016 13:49:33 +0100 schrieb phillip cole:

I would like to sum a range of cells in a column that have specific text
in the comments and display the sum at the bottom of each column. I
have multiple columns i would like to add up. Is this possible using
text in comments?

try following function:

Function ComSum(myRng As Range)
Dim rngC As Range

For Each rngC In myRng
If Not rngC.Comment Is Nothing Then
If Left(rngC.Comment.Text, 1) = "M" Then
ComSum = ComSum + rngC.Value
End If
End If
Next
End Function

and call it in the sheet e.g. with
=ComSum(F2:F4)

Regards
Claus B.
--
Windows10
Office 2016

Thank you Claus,
I copied and pasted that to a module in my spreadsheet. then i set the "sum" cell at the bottom of each column to e.g. "=ComSum(AE720:AE722)". I selected the whole data table and named the range "myRng". It is definitely getting me moving in the right direction but i'm getting some funny results. sometimes its adding the comments with "M". Sometime its adding up all the letters in the cells with comments but putting it in as "MM" versus "2". Sometimes it's not returning a sum if i have letters in the cell "AT" and a comment of "M".
i have attached the results and some other information.
Thoughts?
Thank you

Hi Phillip,

Am Thu, 22 Sep 2016 16:29:29 +0100 schrieb phillip cole:

I copied and pasted that to a module in my spreadsheet. then i set the
"sum" cell at the bottom of each column to e.g. "=ComSum(AE720:AE722)".
I selected the whole data table and named the range "myRng". It is
definitely getting me moving in the right direction but i'm getting some
funny results. sometimes its adding the comments with "M". Sometime
its adding up all the letters in the cells with comments but putting it
in as "MM" versus "2". Sometimes it's not returning a sum if i have
letters in the cell "AT" and a comment of "M".
i have attached the results and some other information.

what exactly do you want to do?
Do you want to sum the cell values with comment text "M"? OF do you want
to count the the comments with text "M"?
Please provide an example workbook with the expectd results in it.


Regards
Claus B.
--
Windows10
Office 2016

Claus,
I appreciate your patience.
I have a resource tracking sheet that summarizes the resources per week and highlights any over allocations. Generally I don't need to know the specific resources for each department but I do want to know that information for my weld department. I designate welding resources by putting a number before the 'W' (#W). I have not been able to sum the numbers in front of the W. I thought I'd try using the comments for the number of welders required so then I could sum the comments. I don't really care how I do it but I would like to figure it out.
I have attached the results I desire.
You will see that I have a formula in all the rows except the 'W' row that works to add the letters in the columns. Any other suggestions would be welcome. I have tried MS Project and several other software programs and they just don't summarize all of my data like I need them to. So, Here we are. Thanks in advance. Phil

Hi Phillip,

Am Tue, 27 Sep 2016 16:04:09 +0100 schrieb phillip cole:

I have a resource tracking sheet that summarizes the resources per week
and highlights any over allocations. Generally I don't need to know the
specific resources for each department but I do want to know that
information for my weld department. I designate welding resources by
putting a number before the 'W' (#W). I have not been able to sum the
numbers in front of the W. I thought I'd try using the comments for the
number of welders required so then I could sum the comments. I don't
really care how I do it but I would like to figure it out.
I have attached the results I desire.
You will see that I have a formula in all the rows except the 'W' row
that works to add the letters in the columns. Any other suggestions
would be welcome. I have tried MS Project and several other software
programs and they just don't summarize all of my data like I need them
to. So, Here we are. Thanks in advance. Phil

the link for the attached workbook is missing.
Have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Tracking"
and download the workbook because macros are disabled in OneDrive.


Regards
Claus B.
--
Windows10
Office 2016

hồng mạ vÃ*ng 24k golden rose (quÃ* tặng) box dùng lÃ*m quÃ* tặng cho gấu, gia đình, vợ má»›i, bạn gái Ä‘ang theo Ä‘uổi ,cặp đôi, vợ cÅ©, bạn gái cÅ©, bạn gái, vợ chồng, bạn gái má»›i, đồng nghiệp, Hoa hồng dát vÃ*ng tặng vÃ*o ngÃ*y 8/3 Hoa hong ma vang thÃ*ch hợp dÃ*nh tặng cho bạn gái những dịp 14/2 Bông hồng mạ vÃ*ng có thể dùng cho quốc tế phụ nữ 20/10

Website: http://hoahong24k.com/hoa-hong-ma-vang

Fantastic post however , I was wanting to know if you could write a litte more on this topic? I'd be very grateful if you could elaborate a little bit more. Cheers!

Thanks a bunch for sharing this with all of us you actually realize what you are speaking about! Bookmarked. Please additionally talk over with my site =). We will have a hyperlink change agreement between us

You should take part in a contest for one of the greatest sites on the net. I'm going to recommend this website!