#Name? error message
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
"Andy" wrote:
On May 9, 1:16 pm, Toppers wrote:
It suggests it is referencing a named "variable" which cannot be "found".
What is the formula in the box/cell?
"Andy" wrote:
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?
=SumTotalHrs(Room1!E28+Room2!E28+Room3!E28)
This formula is supposed to add up values in cells that themselves
have formulas.
Thanks.
|