Use my suggestion


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Eng Teng" wrote in message
...
=SUMPRODUCT(--('Raw Data'!$E1:$E65535<=4))

How do I change the 65535 in above formula to dynamic variable?

Regards,
Tee

"Stefi" wrote in message
...
=SUM(INDIRECT("A1:A"&C1))

Regards,
Stefi

" ezt írta:

C1 = 5
Sum(A1:A{value from cell C1})

How do I assign 5 from cell C1 in above formula ?


Regards,
Tee