Hi Peter,

Did you remember to send me the dataset? It hasn't arrived.

To deal with the problem of the incorrect total, just make the =SUM() part of an =IF() statemnt that excludes the row containing the bank balance if it is hidden. So, for the total you need something like:

Code:
=IF($D9=0,SUM(E10..E25),SUM(E9..E25))

or, if you'd prefer, place an =IF() condition on the adjacent colums containing the prior year and budget figures so that they return 0 if the bank column has 0. For example:

Code:
=IF(D9=0,0,ADGET("gldata.LYM",$B9))


That should work.

(I'm still willing to take a look at the data though.)
_________________________
Andrew Bates