Hi Domenic,

Just replied to your earlier Post. Thanks for further input.

Domenic wrote:
Do the two numbers always occur consecutively in the row?
No

Do the two numbers only appear together once in the row?
Yes

If so, try the following instead...

Assumptions:

D1:H10 contains your 5 columns of data

A1 contains your first criterion, such as 80

B1 contains your second criterion, such as 87

Formula:

=SUM(MMULT((D1:G10=A1)*(E1:H10=B1),TRANSPOSE(COLU MN(D1:G10)^0)))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Cheers
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1