Countif help

[excelexplorer]

Hi All,

I was trying to count the number of people in a range. The condition is that they should have blanks in a column d2 and as well as the conditional formatting of that cell is that the color is red. Is there any way where we can count the number of people who have blanks in cell d2 and as well as the cell color is red??

I am looking at the range of O2:O190 cells, So I am trying to frame a formula in the following way..

COUNTIF(O2:O190, IF(O2= " " && If color of cell is red.. ) can you please help me with the syntax?

Thanks,
Sam.

 

[Skybluekid]

it is saying to count <> in the range $D17:$D180 and = in the range E17:E180