Subtotal

Closed
Mase - Nov 13, 2015 at 02:57 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Nov 13, 2015 at 03:32 PM
Hello,

Im using subtotal and it isn't changing when i hide values.
=SUBTOTAL(109,A42:GA42)

1 reply

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
Nov 13, 2015 at 03:32 PM
So if you hide row 42 the subtotal (i.e. the sum of cells in row 42) doesn't change?

Is calculation set to Manual?
This is the only way I get the same thing happening at my end.
0