He may not have meant it that way, but he did say it <g

Bob

"Don Guillett" wrote in message
...
oops

--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
I read it as Apartments in San Fran, OR Houses in NY, not Apartments or
Houses in San Fran or NY, Actually, it wasn't just the way I read it, he
said that.

--
HTH

Bob Phillips

"Don Guillett" wrote in message
...
or try with { }

=SUMPRODUCT(((A2:A20={"Apartment","House"})*(B2:B2 0={"San
Francisco","New York"})*C2:C20)


--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
=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