Prev: Print all tabs to a pdf file
Next: See if cell is in Range
From: MikeF on 13 May 2010 13:44

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

From: ryguy7272 on 13 May 2010 15:40
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/xlFunctions01.html#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
>
From: Wouter HM on 13 May 2010 15:41
Hi Mike,

As far As I know you can use the SUMIF worksheet function.

In the cell you want the result use

=SUMIF(Detail!A1:A100,Summary!K12,Detail!X1:X100)+SUMIF(Detail!
A1:A100,Summary!K12,Detail!Y1:Y100)+SUMIF(Detail!A1:A100,Summary!
K12,Detail!Z1:Z100)

This is a single formule, adding 3 SUMIG results.

HTH,

Wouter
 | 
Pages: 1
Prev: Print all tabs to a pdf file
Next: See if cell is in Range