=SUMPRODUCT(--('[ESP-2005-10-31.xls]Lab'!$S$74:$AH$95=$B$3),'[ESP-2005-10-31
..xls]Lab'!$AF$74:$AH$95)

I don't think the merged columns matter.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"massi" wrote in
message ...

thanks for your replies.

I have tried to use *sumproduct * but it doesn't work. I don't know if
I made a mistake with the sintax or something else.
the formula is:


=SUMPRODUCT('[ESP-2005-10-31.xls]Lab'!$S$74:$AH$95=$B$3,'[ESP-2005-10-31.xls
]Lab'!$AF$74:$AH$95)

the cell B3 is in my spreadsheet, while the other in the formula refers
to another file.

one thing i didn't say on my previous tread: the column with the name
of the items that i want to compare is made of 13 columns merged and
the one next to it where i actually take the values from is made of 3.
I hope this woudn't make everything even more complicated...

Rgds

Massi


--
massi
------------------------------------------------------------------------
massi's Profile:
http://www.excelforum.com/member.php...o&userid=29202
View this thread: http://www.excelforum.com/showthread...hreadid=489446