=sumproduct((a2:a22="New York")*(b2:b22="Call Centre")*c2:c22)

--
Don Guillett
SalesAid Software

"Griggs" wrote in message
...
I am trting to SUMIF a single range based on 2 columns . I'll explain.
City= New York, Washington, Miami etc
Area = Direct Sales, Call Centre, Third Party etc

Sales in $

How can I create a formula to tell me how much has been sold by the Miami
Call centre?

Thanks
--
Griggs