Forum Discussion
Solved
Excel Formula Issue
I am trying to add a cell on multiple sheets. Basically, it's a move in tally for the month of August. I keep getting this error - #NAME? for this formula - =SUM('0801:0831'!D11) Can someone help m...
Thank you for trying to help me. I have entered each sheet just as you said. 0801 to 0831 w/no spaces. I still can not get the formula to work. HansVogelaar
Try to open attached file in your environment and copy/paste formula from it. File has nothing but
- Sorry, no luck. I got the #REF! error.
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?
- Sure - here it is & thanks so much for your help!!
https://storageassetmanagement-my.sharepoint.com/:x:/g/personal/seppley_storageasset_com/EQObosJ8A-dEvL_MvEkPdNYBjeLHP_RKKgLjbV0Ry60yJQ?e=YKjHZm