So I’ve got an excel document going where each month I am keeping track of data, then using auto sum for monthly totals. After that I do quarterly totals and then a year to date total. Each month, quarter, and YTD are their own sheet. In my sheets for Q1 through Q3, I reference the respective monthly sheets, then autosum the totals and it has worked flawlessly. For Q4, it pulled the monthly totals with no problem, but suddenly autosum does not want to function. I have automatic calculations turned on and the data is in there under general, so it’s not a text issue. I can manually do it no problem, but I’d rather it be an automatic thing so I’m not editing multiple sheets each month. Please help. (there are no error messages either, it’s just not adding the data)

​So I’ve got an excel document going where each month I am keeping track of data, then using auto sum for monthly totals. After that I do quarterly totals and then a year to date total. Each month, quarter, and YTD are their own sheet. In my sheets for Q1 through Q3, I reference the respective monthly sheets, then autosum the totals and it has worked flawlessly. For Q4, it pulled the monthly totals with no problem, but suddenly autosum does not want to function. I have automatic calculations turned on and the data is in there under general, so it’s not a text issue. I can manually do it no problem, but I’d rather it be an automatic thing so I’m not editing multiple sheets each month. Please help. (there are no error messages either, it’s just not adding the data)  Read More

​