What do you mean if row2=A2 ... any cell in row 2 (excluding A2) is equal to
a2 i.e. B2 to IV2? Or is the database a different sheet?

"PaulOakley" wrote:


Hi i need help with an IF statement.

I need it to look at cell A2 then look at the database, and if row 2 in
the database = the same as cell A2 it needs to count the values 'Fail'
in row 4.

Thanks in advance, i hope this makes sense.


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=529968