Is there a formula for counting cells in a range that have notes?

[Dennis62]

I have a forklift tracking sheet that lists forklifts in rows and and inspection comments for every week by columns. I would like to find a way to have a running total of comments per truck (Row). But can't seem to figure a way to do this with formulas. Is there a way to do this?

 

[Fluff]

A formula cannot detect if you have a comment on a cell, so the answer is no.
You could possibly do it with VBA, but there is nothing that will trigger a code, simply because you have added a comment.

 

[Dennis62]

A formula cannot detect if you have a comment on a cell, so the answer is no.
You could possibly do it with VBA, but there is nothing that will trigger a code, simply because you have added a comment.

Thought that would be the answer. I appreciate the response and help.

 

[Fluff]

You're welcome & thanks for the feedback.