Formula that sums the values if you have 2 criteria and 2 differe.

[Guest]

I need a formula that sums the values with 2 different criteria and 2
different look up ranges

 

[Anne Troy]

=sumif(...) +sumif(...)
Using this:
http://www.officearticles.com/excel/sumif_using_multiple_criteria_in_microsoft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Bob Phillips]

=sumproduct(--(rng1=value1),--(rng2=value2),rng1)

will sum the values in rng1 where the two criteria match

--

HTH

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

 

[Anne Troy]

Some day, I'm going to make you or Zack teach me those dashy things, Bob.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Bob Phillips]

Anne,

It's already written it up. See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards

Bob

 

[Anne Troy]

OMG. I don't want to learn all that.
But I'll link to your site, for sure!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Bob Phillips]

OMG. I don't want to learn all that.

You can never learn too much, )

 

[Anne Troy]

I'll stick with learning too much about Word and not quite enough about
Excel, k?
Did you get the reply to my PM?
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

 

[Bob Phillips]

Yes I did thanks, just resurrecting the box.

--

HTH

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

 

[Guest]

Thanks The link to the site was very helpful

Yes I did thanks, just resurrecting the box.

--

HTH

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