On May 9, 3:36 pm, "Peo Sjoblom" wrote:
What is SumTotalHrs? That is why you get the error

--
Regards,

Peo Sjoblom

"Andy" wrote in message

oups.com...

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.


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.