Look at this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Sometimes that site gives me annoying popup messages; no idea why. Anyway,
it is a great resource. Also, look at this:
http://www.contextures.com/xlFunctio...tml#SumProduct

If you can't figure it out after reading that material, post back with a
very SPECIFIC example of what you're doing. I can think of a few things, but
I can't tell for sure what you need.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"MikeF" wrote:


Need to sum columns x,y,z on another sheet by criteria on the original sheet.

So sum columns x,y,z from sheet Detail --- 100 rows, x1:z100 - the sum
range.

Via criteria range on sheet Detail - a1:a100

Where the Detail sheet row matches [lookup?] criteria on sheet Summary k12.

Have looked at it too long!
Any assistance will be greatly appreciated.


Thanx,
- Mike