COUNT IF - Conditional Formatting
Below is the cell I ended up with, however it doesn't work. I tried it on
each county and all returned blank except for Italy and the answer shoud have
been 5, but it returned 176. I also tried putting a range for Col D & E, but
then I got a Do I have something wrong here? What I do know is that there
are a total of 176 100% in the entire column.
=IF(AND('Power CFUs'!$D:$D=$A5,'Power CFUs'!$E:$E=$B5),COUNTIF('Power
CFUs'!$O$6:$O$735,"100%"),"")
"PhilosophersSage" wrote:
Try
=IF(AND(D2="SW",E2="France"),COUNTIF($O2:$O99, "75%"),"")
Where 75% is the condition of green, you can also specify ranges for D2 and
E2 but all in range must meet chriteria.
If this helps click YES.
"KC" wrote:
I need a formula for the following:
If Col D = SW and Col E = France, then count how many green cells are in Col
O. (Column O has conditional formatting of Green, Yellow & Red based on a %,
but I don't want to count the %, just want to count the instances of Green).
Thanks very much!
|