I think that is correct.

--

HTH

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


"massi" wrote in
message ...

the multiple columns at the end are just two because columns from S to
AE are merged as well as AF to AH.
is this going to make things easier?


=SUMPRODUCT(('P:\mypath\2005\[ESP-2005-10-31.xls]Lab-Chem'!$S$74:$S$95=$B$3)
+('P:\mypath\2005\[ESP-2005-10-31.xls]Lab-Chem'!$AF$74:$AF$95=$B$3)*('P:\myp
ath\2005\[ESP-2005-10-31.xls]Lab-Chem'!$AF$74:$AH$95))

by looking at the formula you sent me earlier i think mine should be
ok.
as the columns are merged i think i need to take just the first one to
get my data (in this case the column S and the column AF).


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