Try this:

=SUMPRODUCT(--(ISNUMBER(MATCH(I39:N39,CODE,0))),INDEX(TB,,MATCH( F20,A,0))

Biff

"Sena" wrote in message
...
I am using (index + match) formula to create reports from a list of items.
If
I need to add 2 or more items from the list I replicate the formula with a
plus like this..

=INDEX(TB,MATCH(I37,CODE,0),MATCH($F$20,A,0)) +
INDEX(TB,MATCH(J37,CODE,0),MATCH($F$20,A,0))

Some places I need to add about 10 items from the list, so it is very
hard.

Is there away, that I can use a array formula or some thing similar to
give
the 'lookup' value for match function like below...
={sum(INDEX(TB,MATCH(I39:N39,CODE,0),MATCH($F$20,A ,0)))}

I have used named ranges TB, CODE, MATCH

Thanks

--
Cheers !