That should have been
="Sheet1A"&row(A9)&":A"&row(A9)+counta(A9:A$655 36)-1


"Bob Tarburton" wrote in message
...
You could use indirect ranges such as
=SUMPRODUCT(--(indirect($A$1)=condition1),--(indirect($B$1)=condition2))
Where A1 and B1 name the ranges with formula such as
="Sheet1A"&row(A9)&":A"&row(A9)+counta(A10:A$65536 )-1

Of course indirect can be volatile if you insert or delete columns



"qwopzxnm" wrote
in message ...

Hello-

Is there a way to set up a SUMPRODUCT so that it will automatically
adjust the array length to the last value in a column???

For example if I have column A data that starts in row 9 and ends in
row 50. Part of my SUMPRODUCT would look like --(A9-A50),

Then if I add 5 rows of data could I set up a SUMPRODUCT to
automatically adjust to now include those extra 5 rows?


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile:
http://www.excelforum.com/member.php...o&userid=27557
View this thread:
http://www.excelforum.com/showthread...hreadid=513842