Prevent negative numbers from changing to positive in calculation

  • Thread starter Thread starter robbin
  • Start date Start date
R

robbin

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

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