Specifying a Range.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jocco - 11 Apr 2007 01:10 GMT

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.

Reply to this Message

CLR - 11 Apr 2007 01:21 GMT

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.
>
[quoted text clipped - 4 lines]
>
> Hopefully, the question makes sense. Any help would be greatly appreciated.

Reply to this Message

Ragdyer - 11 Apr 2007 01:54 GMT

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Please bear with me. This is probably a painfully fundamental question.
>
[quoted text clipped - 6 lines]
> Hopefully, the question makes sense. Any help would be greatly
> appreciated.

Reply to this Message

Jocco - 11 Apr 2007 12:26 GMT

Thanks CLR & Ragdyer,

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

> Say you're totaling ColumnA.
>
[quoted text clipped - 18 lines]
> > Hopefully, the question makes sense. Any help would be greatly
> > appreciated.

Reply to this Message

Rate this thread: