"Ragdyer" wrote in
:

=SUMPRODUCT((Sheet2!A1:A8=N(INDIRECT({"A1","A2","A 3","A4"})))*Sheet2!B1
:B8)

Thanks! That did the trick.

Why can't I use CELL("address",A1:A4) instead of the array constant?

--
Posted via a free Usenet account from http://www.teranews.com