Using the current row in a formula

T

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!
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Kevin Vaughn

This appeared to work (in extremely limited testing) :

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

romelsb

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 ?
 
Top