I have a range called MyRange.
I want to put a formula in the cells of a row, somewhere below MyRange that gives the SUM() of cells in MyRange that intersect with the column of the current cell.
Is there some clean way of doing this, using names, and maybe the COLUMN() function, instead of specific addresses in the formula?
Regards
Richard
I want to put a formula in the cells of a row, somewhere below MyRange that gives the SUM() of cells in MyRange that intersect with the column of the current cell.
Is there some clean way of doing this, using names, and maybe the COLUMN() function, instead of specific addresses in the formula?
Regards
Richard