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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is there a formula for counting cells in a range that have notes?
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,717
- Office Version
- 365
- Platform
- Windows
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.
You could possibly do it with VBA, but there is nothing that will trigger a code, simply because you have added a comment.
Upvote
0
Thought that would be the answer. I appreciate the response and help.
Upvote
0
Similar threads
- Question
