Prevent negative numbers from changing to positive in calculation
 

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!!

Prevent negative numbers from changing to positive in calculation
 

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!!