Maybe something like

=SUM(C3:INDIRECT(ADDRESS(ROW(),3)))

HTH
Kostis Vezerides

On Sep 14, 6:51*pm, TopSlice
wrote:
I want to sum the column above current cell using the formula

=SUM(C3:activecell's row - 1)

My question is how do I determine the row number above the current cell.
I know CELL("row") returns the current row but could not *find a way of
using this in the formula.

I know there are ways round this eg. SUM(C3:Cn) *where n is manually entered
but I want to know of a way to do it using an Excel function.