HI Max, I succeeded using your formula with index. I only had to change a ,
to ;

But you have just made my day.

Thank you very much.... :0)

Max wrote:
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})*C 2:INDEX(C2:C50000,COUNT(E2:E50000)))
I hope someone can help me with following issue:

[quoted text clipped - 12 lines]

Thank you in advance.....