Accounting format

G

Guest

Hi,

I have completed a spreadsheet in accounting format. For transaction that
need to be deducted I have entered an '-' thinking that it would be
subtracted in the total which is the sum of all the rows, however this does
not happen - Double the number is deducted. Does anybody know what change I
would need to make to get this working??
Thanks very much
 
B

Bryan Hessey

To have it 'double-deducted' sounds like you have an incorrect formula,
something like the amounts to be subtracted are sub-totalled, and the
grand total is calculated subtracting the amounts AND the subtotal.

Any further clues?

--
 

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

Similar Threads

Calculated Field in Pivot Table minimum value 0
Excel Subtracting multiple columns from another column 3
Mileage log needed Excel 2007 8
percentage calculation problems 0
dividing money 9
convert column headings 4
More Help with Unique Values 1
Subtracting figures in a column 3

Top