Is there a way to find certain text inside comments of cells?
What I'm looking to do is to search through a column of cells and only look for text inside the comments that are placed in the cells IF there are comments in those cells to begin with. So:

1. Find cells with comments
2. Find certain string of text within that comment
3. Take the number in front of the text and use that number to add to the next number that will be found in the next string found

Example:
Comment in C1: "1 V. Term."
Comment in C3: "3 V. Term."

Cell D1: (1 + 3) = 4