Thread: Countifs_two text criteria met and one color criteria met

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.
I run the color module by Chip Pearson, but this gave an error message.

Let me show you the file:
In the sheet 'MIP analysis', I want to have a table which calculates the number of red cells per MIP Dashboard column (see headers in MIP analysis) for the BG [column A in MIP Dashboard] and the right Launch Window [column L in MIP Dashboard] which is selected in cell B2.

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

10000 times thank you for all your thoughts

Many thanks and best regards,

Alinda

Forgot to add:

The reds are manually added (based on different criteria per column) in the now green coloured columns.

The MIP analysis sheet will be the hidden analysis slide, hopefully given an overview of the number of red cells per column per BG per launch window ;-).

Thanks!

This is continued from
Re: Countifs_two text criteria and one color criteria