=SUMPRODUCT(($A$2:INDEX($A:$A,COUNTA($A:$A))="101" )*($B$2:INDEX($B:$B,COUNTA($A:$A))="6")
*($E$2:INDEX($E:$E,COUNTA($A:$A))={4,5,6})*$C$2:IN DEX($C:$C,COUNTA($A:$A)))

--
__________________________________
HTH

Bob

"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.....