#Name? error message

A

Andy

I have this message in a box that calculates a value using values from
a few other worksheets. Can someone tell me how to fix it.

Thanks.

#NAME?
 
P

Peo Sjoblom

Either the error appears in one or multiple cells that you are calculating
with (due to misspelling in those formulas) or the formula in the"box"
itself has misspelled text, for instance if you miss a parenthesis or just
a simple misspelled formula like CONTIF instead of COUNTIF. So check the
spelling in all cells that are part of the calculation
 
T

Toppers

It suggests it is referencing a named "variable" which cannot be "found".

What is the formula in the box/cell?
 
A

Andy

It suggests it is referencing a named "variable" which cannot be "found".

What is the formula in the box/cell?
Click to expand...

=SumTotalHrs(Room1!E28+Room2!E28+Room3!E28)

This formula is supposed to add up values in cells that themselves
have formulas.

Thanks.
 
D

Duke Carey

SumTotalHrs() looks like it's calling a user-defined function. If the
function does not exist in your workbook, you'll get the #Name error
 
A

Andy

What is SumTotalHrs? That is why you get the error
Click to expand...


I was sure that Excel help said to name it which is what I did.
That's my story and I am sticking to it. :)

I changed it to Sum and it now works.
 
Top