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 me figure this out?
10 Replies
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
