Colour Based Counting Formula Help is required

[MYEM1983]

Dear All,

I've applied conditional formatting in one of the column. If condition will meet then the value (in number) in column O will appear in RED COLOUR.

Now at the bottom of that column I want to count how many RED COLOUR figures are appearing. Is there is any way to do that?

My values will start from O41 till O114 at O115, I want to count how many RED COLOUR figures are appearing.

Thanks in advance!!

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.