Size = A2:A5
Depth = B2:B5
Length = C2:C5

In C1 enter:

=SUMPRODUCT((A2:A5=A1)*(B2:B5=B1)*C2:C5)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"nemesis2" wrote in message
...
I have the following

Size Depth Lenght
24 2 4
24 3 6
24 4 8
30 2 10

Cell A1 = 24, Cell B1 = 3. I want the result on C1 to be 6. What would
be
the formula?