Formula for counting values in Red

Peter Kafui Doviavu

I have a conditional formatting in a sheet which colors Red if the due date is passed. Now i need a simple formula to populate all the values in Red in a Metric.

Any Help?

Paul Newcome

You could use a formula along the lines of...

=COUNTIFS(NextDueDate:NextDueDate, @cell < TODAY())

THis will count every date in that column that is less than today (in the past).

Andrée Starå

Hi Peter,

What is the conditional formatting set to? We maybe need to add so-called helper columns for it to work for count.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Peter Kafui Doviavu

Hello Sir,

The Sheet is conditioned to change the values in the row to Red if Date in the 'Next Due Maintenance Date' Column is passed.

Thank you.

Andrée Starå

Happy to help!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Peter Kafui Doviavu

Paul Newcome

You could use a formula along the lines of...

=COUNTIFS(NextDueDate:NextDueDate, @cell < TODAY())

THis will count every date in that column that is less than today (in the past).

Andrée Starå

@Peter Kafui Doviavu,

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée