M
mickjjuk
I am trying to sum the best 2 scores from a total of 4 scores using the LARGE
function. the 4 scores are immediately above the cell containing the
function. I can do the function correctly if there are no hidden rows but it
doesn't work if there are hidden rows within the range that the function is
looking over.
The funtion I have is =SUM(Large(A1:A4,ROW(INDIRECT("1:"&C1))))
in cell C1 i have 2.
This works if there are no hidden rows, if I insert a row and then hide this
row the function does work but picks up the value in the hidden row if that
value is recognzed as 1 of the 2 largest values. I do not want any values
in the hidden rows to be included in the SUM.
Thanks
function. the 4 scores are immediately above the cell containing the
function. I can do the function correctly if there are no hidden rows but it
doesn't work if there are hidden rows within the range that the function is
looking over.
The funtion I have is =SUM(Large(A1:A4,ROW(INDIRECT("1:"&C1))))
in cell C1 i have 2.
This works if there are no hidden rows, if I insert a row and then hide this
row the function does work but picks up the value in the hidden row if that
value is recognzed as 1 of the 2 largest values. I do not want any values
in the hidden rows to be included in the SUM.
Thanks