software

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: www.excelforum.com/member.php...oamp;userid=25103
View this thread: www.excelforum.com/showthread...hreadid=529968What 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?

quot;PaulOakleyquot; wrote:

gt;
gt; Hi i need help with an IF statement.
gt;
gt; I need it to look at cell A2 then look at the database, and if row 2 in
gt; the database = the same as cell A2 it needs to count the values 'Fail'
gt; in row 4.
gt;
gt; Thanks in advance, i hope this makes sense.
gt;
gt;
gt; --
gt; PaulOakley
gt; ------------------------------------------------------------------------
gt; PaulOakley's Profile: www.excelforum.com/member.php...oamp;userid=25103
gt; View this thread: www.excelforum.com/showthread...hreadid=529968
gt;
gt;