Oz,

Use

=SUMPRODUCT(--(B2:B20C2:C20))

etc.

--

HTH

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


"ozcank" wrote in
message ...

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


--
ozcank


------------------------------------------------------------------------
ozcank's Profile:
http://www.excelforum.com/member.php...fo&userid=5328
View this thread: http://www.excelforum.com/showthread...hreadid=484779