Multiple countifs

O

ozcank

Hi All

Ok, what I would like to do is use multiple countif functions in 1
cell. I have a list of values in column C, and a corresponding
tolerance in column B. So basically, it's something like if C2 > B2,
then count as 1, if C3 < B3, then count as 1, if C4 = B4, then count
as 1, if C5 > B5, then count as 1, etc.

I want to be able to count the number of cells in column C that meet
the criteria against their targets in column B. Is this possible?

I hope this makes sense

Much appreciated

Oz
 
B

Bob Phillips

Oz,

Use

=SUMPRODUCT(--(B2:B20>C2:C20))

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
O

ozcank

Thanks Bob

The problem was that each cell criteria differed from the one above
some cells were to be counted if they were less than the value in th
next column, others to be counted if they were more and others if the
were equal. I think I have it worked out. I can get the result if
use

=SUM(K4>$D4)+SUM(K5<$D5)+SUM(K6<$D6)+SUM(K7=$D7) etc

which seems to work.

Thanks for the reply, much appreciated

O
 
Top