Auto Adding

appletonthecat 

I"ll take another look at the file in the morning, but I'm pretty sure I'm going to come back and suggest a radical reorganization of it.

First I have to figure out what it all IS in the first place. You're familiar with it, so it may seem obvious to you. What, for example, are the various line entries under each month, under the headings of "Takings" and "Costs"--as well as the section in the middle that seems to lack a heading other than the month name, which presumably applies to all three sections? 

But very seriously, this may be a way to organize data so that you as a human can look at it and make sense of it, but it's NOT a way to organize it to take optimum advantage of Excel. Assuming it has something to do with tracking income and/or expenses on a monthly basis, you'd be FAR better off learning to create it as a transactional database--same data you have now, just keeping it all as one table, letting the dates alone take care of whether it's the month of Jan or Feb or Mar.....

I'm attaching yet another example of how that could work, letting the Pivot Table do all the heavy lifting. See if it makes sense. You can learn to do it later--not as hard as you might think. In fact, a LOT easier than making what you have so far work and work reliably.  Notice the sheet called "Raw Data" and then the one labelled "Summary."  ALL of the summarized data on the summary sheet was handled by the Pivot Table tool; not a single formula had to be entered. That's how powerful the tool is. And as you can see, it's broken out by month and category......