Using the current row in a formula

[tinyguppie]

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!

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Guest]

This appeared to work (in extremely limited testing) :

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

 

[Guest]

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 ?