Forum Discussion
Excel formulas not working across multiple sheets
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, qu...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Each monthly total formula is correct because they're identical (with the exception of the actual month) to the other quarterly sheets.
- The status bar in the bottom left of your screen capture indicates a circular reference in E8. You may want to resolve that first.
- https://filetransfer.io/
You can share your Excel file by above url.- Sick thank you!
https://filetransfer.io/data-package/KNtI0CEq#link
let me know if that works
- This is an image, but not a sample workbook, as Hans had requested. Please post either an actual copy of your workbook or a reasonable mockup (with false data) if the actual is confidential.
- yeah I don't know how to do that so a screenshot with the formula showing is the best I got
