Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |