Countifs statement checking for number of red cells under 2 conditions

[alinda]

Dear all,

It would be great if you could help me with the following.

My Issue:
I need Excel to count the number of cells that meet Criteria A (text), Criteria B (text) and Criteria C (red color).

I tried to do this with:=Countifs (range “column A”, Criteria A “text”, range “column B”, Criteria B “text”, range “column C”, Criteria C color red).

For Criteria C I however do not know which formula to use to get the criteria “red cell”. I tried all, but nothing worked.


Hope you’ll be able to provide me with the answer how to do this.

Many thanks and best regards,

Alinda

 

[anglais428]

are your red colored cells based on conditional format or manuely colored red?

 

[alinda]

No, it is based on manual coding.. Thanks!