Microsoft Excel - IF statements - Asked By susan on 05-Jan-11 06:49 AM

How do I write an IF statement to show:

IF Column B is equal to BEA and Column H is equal to 1 add up the figures in Column S?

Thank you

IF statement in which language?. - Lalitha Kumaran replied to susan on 05-Jan-11 06:55 AM

Specify the language to provide if condition for your requirement

Jackpot . replied to susan on 05-Jan-11 06:56 AM
Hi Susan

Try
=SUMPRODUCT((B1:B100="BEA")*(H1:H100=1),S1:S100)

If you are using XL2007/2010 versions try
=SUMIFS(S:S,B:B,"BEA",H:H,1)
Panji Tengkorak replied to susan on 05-Jan-11 07:02 AM
result as string

=IF((AND(B1="BEA",H1=1)),B1&H1,0)

result as number

=IF((AND(B1="BEA",H1=1)),B1+H1,0)