You could simply use the smallest max expected extent, say row 50000:
=SUMPRODUCT((A2:A50000="101")*(B2:B50000="6")*(E2: E50000={4;5;6})*C2:C50000)

Another way, assuming col E will determine the last row of data, and that
data in E2 down will be contiguous nums right down (ie no blank cells
in-between), then this:
=SUMPRODUCT((A2:INDEX(A2:A50000,COUNT(E2:E50000))= "101")*(B2:INDEX(B2:B50000,COUNT(E2:E50000))=" 6")
*(E2:INDEX(E2:E50000,COUNT(E2:E50000))={4;5;6})*C2 :INDEX(C2:C50000,COUNT(E2:E50000)))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"micro1000" <u48676@uwe wrote in message news:8fdda63bd2cb0@uwe...
I hope someone can help me with following issue:

I am using a sumproduct formula ---
=SUMPRODUCT(($A$2:$A$12569="101")*($B$2:
$B$12569="6")*($E$2:$E$12569={4;5;6})*$C$2:$C$1256 9)

As you can see It starts with row number 2 and in this case ends at 12569.
My
problem is that the area E2:E12569 comes from a query from another
program.
Next time I run this query it may end up with another row number (ex.
11876
or 33215) Can i make my sumproduct formula count the number of rows and
automatically insert this number in the formula???

Thank you in advance.....