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

--
Regards,

Peo Sjoblom


"Andy" wrote in message
ups.com...
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?