Specifying a Range.

J

Jocco

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.
 
C

CLR

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

=G1-SUM(A10-A57)

Vaya con Dios,
Chuck, CABGx3


Jocco said:
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
Click to expand...
appreciated.
 
R

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

Jocco

Thanks CLR & Ragdyer,

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