Can anybody help with this please?
I need to sum a column of figures. The number of rows in the column will be variable, but will be a contiguous range, with no gaps.
The range for the sum will start at the first row after the nearest blank cell above the current cell, & end at the cell above the current cell.
For example: cell C16 blank, cells C17-21 non-blank, cell C22 contains an argument which returns the range C17:C21.