Hi,

Try this

=SUM(INDIRECT("C3:C"&CELL("Row")-1))

Mike

"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.