Nested IF statements

[basavarajkh]

Hi, I need a nested formula,


Data's are stated below:


In column A = City Name ( Bangalore, Simla ), Column B = City Code 1,2 and 3 and In column c = Amount.


I need the sum of amount for city code 1 for Bangalore city.


Thanks.

 

[Hui]

=Sumproduct(1*(City_Name_Range = "Bangalore, Simla")*(City_Code_Range = 1)*(Amount Range) )

 

[Luke M]

=SUMPRODUCT(--(A2:A100="Bangalore"),--(B2:B100=1),(C2:C100))

 

[basavarajkh]

Thank you Chandoo...