Hi,

Though sumproduct is a better formula to use, here is an array formula
alternative (Ctrl+Shift+Enter)

=sum(if((rangeA=length)*(rangeB=width)*(rangeB=thi ckness),rangeC))

Regards,

Ashish Mathur

"Tomek S" wrote:

I have one question. I think it will be simple for You.

For exaple I have array:

Length Width Thickness Mass
40 40 2,0 1
40 40 3,0 2
40 40 3,5 3
40 60 2,0 5
40 80 3,0 8

I would like to find a value of mass when I know value of Length, Width and
Thickness. How can I do it? Do You have any suggestions?


BSTR

Tom