Hi Harlan Grove,

When you get a chance. Can You explain step by step how this formula
works*?*


SUMPRODUCT((T(OFFSET(INDIRECT("'"&WSL&"'!A4:A30"), ROW(INDIREC
T("4:30"))-4,0,1,1))=A4)*(N(OFFSET(INDIRECT("'"&WSL&"'!D4:D30 ),ROWINDIREC
T("4:30"))-4,0,1,1))0)


--
Fin Fang Foom
------------------------------------------------------------------------
Fin Fang Foom's Profile: http://www.excelforum.com/member.php...o&userid=36516
View this thread: http://www.excelforum.com/showthread...hreadid=477377