Using the current row in a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tinyguppie@hotmail.com - 19 Oct 2006 19:06 GMT

This is probably a simple question :)

I have a formula where I would like to reference a different column in
whatever row the formula is in.

Something along the lines of

=SUM( A:ROW()...C:ROW() )

which would sum up column A to column C for whatever row youre
currently in.

Thanks!

Reply to this Message

Bob Phillips - 19 Oct 2006 19:42 GMT

=SUM(OFFSET(A1,0,0,ROW(),3))

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> This is probably a simple question :)
>
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

Kevin Vaughn - 19 Oct 2006 19:53 GMT

This appeared to work (in extremely limited testing) :

=SUM(INDEX(A:A,ROW()):INDEX(C:C,ROW()))

Signature

Kevin Vaughn

> This is probably a simple question :)
>
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

romelsb - 21 Oct 2006 01:33 GMT

Excuse me Kevin n Bob....Mr. tinyg - please be specific ..Do you want to sum
the values of all cells within Columns A to C, or sum a range that are from
row 1 to row() , column A to C ?

> This appeared to work (in extremely limited testing) :
>
[quoted text clipped - 13 lines]
> >
> > Thanks!

Reply to this Message