URGENT - SUMIF(AND
 

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

URGENT - SUMIF(AND
 

why dont you use a pivot table instead ?

URGENT - SUMIF(AND
 

=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

URGENT - SUMIF(AND
 

hi Griggs

=sumproduct(--(a2:a1000="miami")*(b2:b1000="call centre");(c2:c1000))

hth
regards from Brazil
Marcelo

"Griggs" escreveu:

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