Using the current row in a formula
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 ?
"Kevin Vaughn" wrote:
This appeared to work (in extremely limited testing) :
=SUM(INDEX(A:A,ROW()):INDEX(C:C,ROW()))
--
Kevin Vaughn
" wrote:
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!
|