Need Excel If Condition

[riyaju]

Hi there,

Hi I am using Excel 2010,

I have some Country name in Column name 'A' also DEST in column 'B' and amount in column 'C',

So I need

in A22 = SUM(IF(COUNTRYNAME="SINGAPORE" AND DEST="O")
IN B22= SUM(IF(COUNTRYNAME="SINGAPORE" AND DEST="C")

in A24 = SUM(IF(COUNTRYNAM!E="SINGAPORE" AND DEST="O") (NOT EQUAL TO SINGAPORE)
IN B24= SUM(IF(COUNTRYNAME!="SINGAPORE" AND DEST="C") (NOT EQUAL TO SINGAPORE)

How to SUM of above it???

[Special-K]

A22
=sumifs(c2:c16,a2:a16,"singapore",b2:b16,"o")
b22
=sumifs(c2:c16,a2:a16,"singapore",b2:b16,"c")
a24
=sumifs(c2:c16,a2:a16,"<>singapore",b2:b16,"o")
b24
=sumifs(c2:c16,a2:a16,"<>singapore",b2:b16,"c")

[vlady]

or maybe with sumproduct

=SUMPRODUCT(--(C2:C16),--(A2:A16="singapore"),--(B2:B16="c"))
=SUMPRODUCT(--(C2:C16),--(A2:A16="singapore"),--(B2:B16="o"))

=SUMPRODUCT(--(C2:C16),--(A2:A16<>"singapore"),--(B2:B16="c"))
=SUMPRODUCT(--(C2:C16),--(A2:A16<>"singapore"),--(B2:B16="0"))