View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default #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.