SUMIF with Mutiple Ranges & Criteria

P

PokerZan

I'm doing a sales report and have a single sheet with all my call/resul
metrics on it.

I want to use SUMIF (I think ;) ) to calculate the cells in
particular column if a cell in a specific column has a specific tex
entry as well as a different text entry in another column (the tw
columns are region and district). I know how do do a singl
range/criteria in a SUMIF statement, but I don't know how to ad
multiple SUMIF range/criterias.

So basically here is what I am looking for:

Sum a particular column G if column F equals "East Enterprise" an
column V equals "CSI".

I am currently breaking these out in a pivot table and adding
seperate sheet to the report, then doing a sumif statement on th
columns I need but I know there has to be a way to do it in a singl
formula, it is just beyond my grasp.

Also, if this makes no sense whatsoever, FLAME away... that just may b
the movitation I need today.

Humbly,

PokerZa
 
B

Bob Phillips

=SUMPRODUCT(--(F2:F100="East Enterprise"),--(V2:v100="CSI"),G2:G100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
P

PokerZan

Thanks Bob,

It did the trick! :cool:

One quick question though, what do the "--" do before the parenthese
do?

PZa
 
P

PokerZan

And the questions never stop... :p

There are about 7 different options that could be in column V, I a
only looking to extract "CSI", the others I want to add up the other
options...

So is there an way to add up all that DON'T say "CSI" in column V?

Thanks,
PZa
 
Top