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...
Make sure that your workbook contains sheets named 0801 and 0831, spelled exactly like that, without spaces before or after.
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?
