Forum Discussion

SarahMichelle72's avatar
SarahMichelle72
Copper Contributor
Aug 05, 2023
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...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 10, 2023

    SarahMichelle72 

    Is does compute correctly in your sample workbook:

     

    The total 11 is the result of:

HansVogelaar's avatar
HansVogelaar
MVP
Aug 05, 2023

SarahMichelle72 

Make sure that your workbook contains sheets named 0801 and 0831, spelled exactly like that, without spaces before or after.

  • SarahMichelle72's avatar
    SarahMichelle72
    Copper Contributor
    Aug 09, 2023

    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 

      • SarahMichelle72's avatar
        SarahMichelle72
        Copper Contributor
        Aug 09, 2023
        Sorry, no luck. I got the #REF! error.

Resources