Maybe some of the entries are text, although they look like negative numbers. You can easily check with the ISNUMBER() function.
Text cells are excluded from the SUM()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"robbin" wrote in message ...
| On worksheet Page 1 (for example), I have referenced a group of numbers to
| calculate from worksheet Page 2. All the numbers in this reference group are
| negative numbers, but the calculation shows them as positive numbers. This is
| not the case for every calculation but occurs sporadically within this file.
| The formula of the negative numbers shows them with a '-' preceding the
| number. The formula of the calculation shows '=sum(cells referenced on Page
| 1). Why is this happening and how can it be fixed? HELP!!
|
| Thanks!!