Formula that counts the total of red dot symbols in my status column

axelrodo

Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline.

In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are in the project plan. Does someone know a formula that works for that?

Carson Penticuff

You will want to setup a cross sheet reference to be able to access the information from your source sheet. Your formula would then be something similar to:

=COUNTIF({Status}, "Red")

Where {Status} is your label for the reference to the source sheet.

Carson Penticuff

You will want to setup a cross sheet reference to be able to access the information from your source sheet. Your formula would then be something similar to:

=COUNTIF({Status}, "Red")

Where {Status} is your label for the reference to the source sheet.

axelrodo

Hey Carson, thank you for the quick answer! What's a cross sheet reference?

axelrodo

Hang on, I've found something on YouTube. All good, thanks!

Carson Penticuff

👍️

Just respond back if you need any help getting it setup.