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!