Sum should be negative


C

CQ

I have a sum formula that totals a column that includes IF formulas. The
column displays -2.5 in the first field, the remaining fields that make up
the total are zero. The total displays 2.5, a positive rather than a
negative. The formula in the total is =SUM(AI8:AI33). When I copy and paste
the column it shows up as follows. The positive numbers displayed do not
appear in excel, nor should they. To complicate things additions to this
column add to the total of the next column. There is not reference to these
cells in the second column.
-2.50
3.00
0.00
1.00
0.00
1.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2.50
 
Ad

Advertisements

S

Shane Devenshire

Hi,

What is the format that is applied to A18:AI33?

what does this statement mean: "The positive numbers displayed do not appear
in excel, nor should they."? You show us positive number but say they aren't
there???

Please clarify

Thanks,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top