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.