Thanks for replying. The problem is that my range can consist of A LOT
of areas, which would mean a very long formula of sumproduct entries
(but of course it is possible to program it, I will if there is no
other option...). The second suggestion to define the areas using 1
name does not work. It still gives an error....

Jurry.


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