Thanks, seeing the data is so much easier to know what is happening

No you cant add e33 to another number to get the result in e33 as excel doesnt know what e33 was prior to the latest 2 numbers

in my opinion you have 2 choices, have another cell to do the addtion and the type in back to E33 (which is rubbish) or create another sheet (or column on the same sheet) for the data entry then its a simple sum formula then copy paste speical on teh last day of the month - or even better a sumif

See the data on sheet2 and the 2 formulas in E & F

Attached Files

Circular ref problem_purfleet.xlsx (11.4 KB, 9 views)

I want to update E33 every day. I've stuck an extra sheet into the workbook to do the daily update but it is hardly any improvement as I then have to start with that sheet, enter the value for the current day, the calculation of the new total then happens in the sheet but now I have to copy that value, return to the main sheet and paste special. This seems to work, but an elegant improvement it certainly is not. Also I am unfamiliar with SUMIF and from what I've discovered, I see no relevance.


It is starting to look as if there is no improvement available to the position I am currently in.
Thanks for your time,
Tony

I've not done any programming for 40 years but if it can do better than where I'm at currently, then I'll give it a go.