ok, that works a treat, but...

sometimes I am putting money into the account, under that reference (38) and it has nothing to do with food, it might be for bills etc. As far as I could see, with the formula you gave me when 38 if the reference it will always add 100 to the food total unless there is an amount in the money out column. Could you maybe refer the formula to the amount of 607.75???? Is that asking too much?

Also I would like to be able to copy the formula to the bills total section. I would probably have to rearrange/rename my columns to do that though.

Sorry if I haven't explained myself properly