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.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.