=SUMPRODUCT(((A2:A20="Apartment")*(B2:B20="San
Francisco")+(A2:A20="House")*(B2:B20="New York")),C2:C20)
for one way
--
HTH
Bob Phillips
"Alejandro" wrote in message
...
In the following example how can I add all the comissions for Apartments
in
San Francisco or Houses in New York using SumIf for example??
Type Property Value Commission
Apartment San Francisco 7,000
House New York 14,000
Apartment New York 21,000
Apartment San Francisco 13,000
House San Francisco 28,000
Apartment New York 8,000
|