Variable row number in Sum($A$1:A10) formula


M

Migo1

I need to be able to change the length of the string of numbers in a column
being added using the Sum formula such as: =Sum($A$1:A10), where A10 is a
variable adjusted by a reference to the number of rows to add in an different
cell (C1).
For instance, if C1 is the reference cell and C1 = 20, the the fomula should
automatically change to =Sum($A$1:A20).
How can this be accomplished?
 
Ad

Advertisements

Ad

Advertisements

T

T. Valko

Another one...

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

If C1 is an empty cell the entire range will be calculated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top