Count notes in Excel

Question

Hi,

I have different cells with different notes, these notes are invoice numbers.

Is there a way to count the notes from each cell and dislapy the result in another cell?

Thank you so much.

Answer 1

. . . I appreciate your kind attention, but what I'm trying to do, is count the number of notes that I add to each cell . . .

Hi,

This can only be found using VBA.

Solution Workbook Link: Count_Notes_6_Aug.xlsm

Code

Sub Count_Notes()

On Error GoTo ErrorHandle

ThisWorkbook.Worksheets("Sheet1").Range("A1").Value = ThisWorkbook.Worksheets("Sheet1").Range("E1:E10000").SpecialCells(xlCellTypeComments).Count

Exit Sub

ErrorHandle:

ThisWorkbook.Worksheets("Sheet1").Range("A1").Value = 0

End Sub

The above code:

1. Will go to worksheet Sheet1

2. In worksheet Sheet1 >> the code will evaluate range E1:E10000

3. Will write the count of notes in cell A1.

If required, please modify the bold part in the above-code to suit Your requirement.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 2

Hi Waqas,

I appreciate your kind attention, but what I'm trying to do, is count the number of notes that I add to each cell.

I hope I've explained myself.

Thank you.

Answer 3

Dear Adrian Olvera Contreras,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

If you want to count invoice numbers from Non-Contiguous Range in Excel, you may use COUNTIF

Here is assuming data and the formula count the invoice numbers.

If above is not your scenario, please feel free to upload your Excel data sheet view for your reference so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***