"Serge" wrote:
On sheet one I have:
Columns;C, D, E, J & Rows; 9, 10, 11, 12, 13, 14
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)
Columns: A (size), B (length), C (quantities)
& rows 20, 21, 22 for A325 and
rows 32, 33, 34 for SAE.
.. 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 & length.

In Sheet2,

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)
C20 copied to C22

In C32:
=SUMPRODUCT((Sheet1!$D$9:$D$14=A32)*(Sheet1!$J$9:$ J$14=B32)*(Sheet1!$E$9:$E$
14="SAE"),Sheet1!$C$9:$C$14)
C32 copied to C34

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---