Dynamic variable in formula ?

[engteng]

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

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


Regards,
Tee

 

[Bob Phillips]

=SUM(A1:INDEX(A:A,C1))

--
---
HTH

Bob


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

 

[Stefi]

=SUM(INDIRECT("A1:A"&C1))

Regards,
Stefi

„[email protected]†ezt írta:

 

[Dana DeLouis]

=SUM(OFFSET(A1,0,0,C1,1))

--
HTH :>)
Dana DeLouis

 

[Eng Teng]

=SUMPRODUCT(--('Raw Data'!$E1:$E65535<=4))

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

Regards,
Tee

 

[Bob Phillips]

Use my suggestion


--
HTH

Bob

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