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:

SarahMichelle72's avatar
SarahMichelle72
Copper Contributor
Aug 10, 2023
It's looking like it works, but it is not computing correctly.
HansVogelaar's avatar
HansVogelaar
MVP
Aug 10, 2023

SarahMichelle72 

Is does compute correctly in your sample workbook:

 

The total 11 is the result of:

  • SarahMichelle72's avatar
    SarahMichelle72
    Copper Contributor
    Aug 10, 2023
    Hans!! You just made my day!! You are AWESOME!! Thanks for clarifying this for me. Have a great rest of your day!! 😊

Resources