URGENT - SUMIF(AND

G

Guest

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
 
G

Guest

hi Griggs

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

hth
regards from Brazil
Marcelo

"Griggs" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically decide column in sumif formula 6
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Help 3
Using SUMIF and AND functions simultaneously 3
Copying and Adding Values 1
Expression in Conditional macro 6
Pivot Tables (Sumif) 4
please help with my code below 4

Top