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" wrote in message
...
Anne,

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

Regards

Bob


"Anne Troy" wrote in message
...
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" wrote in message
...
=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)


"Inga" wrote in message
...
I need a formula that sums the values with 2 different criteria and 2
different look up ranges