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 10, 2023

SarahMichelle72 

The formula in D12 is

='0802'!D12='[sum multishits (1).xlsx]Sheet1'!$D$21=SUM('0801:0831'!D11)

which doesn't make sense.

The formula

=SUM('0801:0831'!D11)

does work:

 

SarahMichelle72's avatar
SarahMichelle72
Copper Contributor
Aug 10, 2023
It's looking like it works, but it is not computing correctly.
  • 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!! 😊
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 10, 2023

    SarahMichelle72 

    Is does compute correctly in your sample workbook:

     

    The total 11 is the result of:

Resources