I'm trying to do something that is probably pretty simple. I want to SUM the values in a column, but I want to stop summing at the cell number based on the INT value in another cell. I tried this: =sum(A1:A(B1)) where the INT value is stored in cell B1, but it doesn't work. Can anyone help me with this? Thank you!
1 Answer
Use INDEX it is non-Volatile:
=SUM(A1:INDEX(A:A,B1)) 
