Another reason for the use of a dynamic created range is that in this
way cells with "N/A" are already discarded. So they will not mess up
the sumproduct calculation (or is there a method to exclude the "N/A"
cells from that calculation, other than making an additional row on the
sheet?).

Jurry.


--
Jurry
------------------------------------------------------------------------
Jurry's Profile: http://www.excelforum.com/member.php...fo&userid=8664
View this thread: http://www.excelforum.com/showthread...hreadid=278230