Dear all,
I am trying to write a formula that sums up only the visible cells in a worksheet, so that the sum only represents autofiltered data. In theory, SUBTOTAL should do this, but I find the formula I have written continues to return the sum of teh entire column, with the hidden cells included.
The formula is as follows:
=SUBTOTAL(9,(OFFSET($F$1,1,0))
INDIRECT(CONCATENATE("F",(COUNTA(OFFERCOUNT)+1)))))
'(COUNTA(OFFERCOUNT)+1)' returns the row number of the last row of data (which changes). OFFERCOUNT is a defined named range....
Can anyone tell me what i am doing wrong?
With best wishes,
Max
I am trying to write a formula that sums up only the visible cells in a worksheet, so that the sum only represents autofiltered data. In theory, SUBTOTAL should do this, but I find the formula I have written continues to return the sum of teh entire column, with the hidden cells included.
The formula is as follows:
=SUBTOTAL(9,(OFFSET($F$1,1,0))

'(COUNTA(OFFERCOUNT)+1)' returns the row number of the last row of data (which changes). OFFERCOUNT is a defined named range....
Can anyone tell me what i am doing wrong?
With best wishes,
Max