Excel Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Sorry, this will seem really simple but I haven't used excel in about 10
years and have been trying to get this sorted for hours. Here goes:

I have column C and D and need to get the sum of these two columns
calculated and shown in column E.

e.g C D E

+200 200.00
-100 100.00
-20 80.00
+120 200.00

I have no real idea how to add a formula, apparently, as every way I tried
did not work

Please help me before I go insane.

Thanks in advance
 
One way:

E1: =C1+D1
E2: =E1+C2+D2

Copy E2 down as far as necessary.

OR, if you want the result in column E to be blank unless there's a
value in C or D:

E2: =IF(COUNT(C2:D2),E1+C2+D2,"")
 
Hi

Thanks very much for the reply and I'm sorry I have taken so long to read it.

I have tried to do what you suggested but to no avail. To be honest, I am
not even sure if I am highlighting the correct cells when I am putting the
formula in!! Sad, I know.

I am doing this as I have an accounts sheet, as below, where C is the debit
column and D is the credit column. I then need column E to show the total.
So, if there is a credit of 200.00 and then on the next line a debit of
100.00, E should read 100.00. But it doesn't.

DATE DETAILS (Invoice No.) DEBIT CREDIT BALANCE



Please help!!!

Thanks
 
Hi

Thanks very much for the reply and I'm sorry I have taken so long to read it.

I have tried to do what you suggested but to no avail. To be honest, I am
not even sure if I am highlighting the correct cells when I am putting the
formula in!! Sad, I know.

I am doing this as I have an accounts sheet, as below, where C is the debit
column and D is the credit column. I then need column E to show the total.
So, if there is a credit of 200.00 and then on the next line a debit of
100.00, E should read 100.00. But it doesn't.

DATE DETAILS (Invoice No.) DEBIT CREDIT BALANCE



Please help!!!

Thanks
 
Back
Top