Searching for multiple conditions

[Guest]

I have the following formula in Cell N75 on 'ledger' page which puts an 'X'
in the selected cell when the two conditions are met.

=IF(SUMPRODUCT(--('WE 30.07.04'!$A$4:$A$112=72),--('WE
30.07.04'!$C$4:$C$112=$A75)),"X","")

What I want to do is add a third condition.

The formula is looking for specific values in columns A and C but I would
like it to include column H also.

On any given row in 'WE 30.07.04', if A= 72, C= 4 and H='Y', then I would
like the 'X' to appear.

Can anybody help?

Many thanks in advance

Lee Kelly

 

[Jerry W. Lewis]

Just extend the pattern

=IF(SUMPRODUCT(--('WE 30.07.04'!$A$4:$A$112=72),
--('WE 30.07.04'!$C$4:$C$112=$A75)),
--('WE 30.07.04'!$H$4:$H$112="Y")),"X","")

Alternately, with 2 or more conditions, you could multiply the
conditions instead of using -- to coerce them into numbers

=IF(SUMPRODUCT(('WE 30.07.04'!$A$4:$A$112=72)*
('WE 30.07.04'!$C$4:$C$112=$A75))*
('WE 30.07.04'!$H$4:$H$112="Y")),"X","")

Jerry