I created a template to break down monthly expenditures for an NGO I volunteer with. The data is on one worksheet and then I have a worksheet for each month with total expenditures. I copied and pasted the formulas and every month but August works fine. I am totally baffled by why August won't work since the formulas were copied and pasted with me only changing the section of the formula for the month. My guess is that something is different about the data entry for August, but no mater how much I look at it I can't figure out anything that is different than the other months. I am a very novice excel user and the answer would probably be obvious to someone who uses excel a lot so I'm asking for suggestions about what can be different about the data entry, or cell formatting that would cause the formula to not work. I don't get an error message, it just isn't calculating the data.
Thanks!
Heather