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))

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy