Why not super-size? In place of:
$A$2:$A$9487
use:
$A$2:$A$65535


etc.
--
Gary''s Student - gsnu2007k


" wrote:

Hi

I have following sumproduct:

=SUMPRODUCT(($A$2:$A$9487="101")*($B$2:$B$9487="0" )*($E$2:$E$9487=
{4;5;6})*$C$2:$C$9487)

My problem is that my sheet always starts at row #2 but the numbers of
rows change from time to time - so I need excel to count the numbers
of rows and automatically place it where 9487 is placed today.

Can someone help me?

Thank you ind advance

Mikael