Specifying a Range.

[Guest]

Please bear with me. This is probably a painfully fundamental question.

I need to specify a range of 48 cells in a sum formula. For example,
=SUM(A10:A57). Is there another way to achieve the same results by
subtraction? Something like, =SUM(The cell I want to end with - the quantity
of cells)?

Hopefully, the question makes sense. Any help would be greatly appreciated.

 

[CLR]

Perhaps you mean something like this.......

=G1-SUM(A10-A57)

Vaya con Dios,
Chuck, CABGx3

Please bear with me. This is probably a painfully fundamental question.

I need to specify a range of 48 cells in a sum formula. For example,
=SUM(A10:A57). Is there another way to achieve the same results by
subtraction? Something like, =SUM(The cell I want to end with - the quantity
of cells)?

Hopefully, the question makes sense. Any help would be greatly

appreciated.

 

[Ragdyer]

Say you're totaling ColumnA.

You can put the starting row number in B1, and the ending row number in B2:

=SUM(INDEX(A:A,B1):INDEX(A:A,B2))

OR

You can put the ending row number in B2, and the number of rows to subtract
in B1:

=SUM(INDEX(A:A,B2-B1):INDEX(A:A,B2))

 

[Guest]

Thanks CLR & Ragdyer,

I know I wasn't very clear with my description, but Ragdyer actually had
just the solution I was looking for.