COUNT IF - Conditional Formatting

K

KC

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!
 
P

PhilosophersSage

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.
 
K

KC

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%"),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top