On Sheet2, enter this formula in C20:

=SUMPRODUCT((Sheet1!$D$9:$D$14=A20)*(Sheet1!$J$9:$ J$14=B20)*(Sheet1!$E$9:$E$
14="A325")*Sheet1!$C$9:$C$14)

And copy down to C22.

In C32 enter:

=SUMPRODUCT((Sheet1!$D$9:$D$14=A32)*(Sheet1!$J$9:$ J$14=B32)*(Sheet1!$E$9:$E$
14="A325")*Sheet1!$C$9:$C$14)

And copy down to C34.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Serge" wrote in message
...
On sheet one I have: Columns;C, D, E, J & Rows; 9, 10, 11, 12, 13, 14 as
an
example.
Column: C is for quantities, D is for sizes, E is for grades, J is for
length
: C D E J
------------------------------------------
9: 4 .625 SAE 1.50
10: 6 .625 SAE 1.50
11: 4 .500 A325 1.75
12: 6 .500 A325 1.75
13: 8 .500 SAE 1.50
14: 6 .75 A325 2.25

On sheet two (summary sheet) I have the following as example:
Columns: A (size), B (lenght), C (quantities) & rows 20, 21, 22 for A325
and
rows 32, 33, 34 for SAE.
I would like to see a total quantity shown in column C if I type in size
in
column A and length in column B for each sizes of same grade & lenght.

I get confused with SUMIF or SUMPRODUCT. Can someone un-confuse me with
this
problem please.
Thank you in advance.
Serge