# Adding columns A and B to get a result in C

#### JulianMS

##### New Member
Hi all.

This may seem a simple question but I cant seem to find an answer in help. It all seems to refer to adding rows and not columns.

I am doing a budget type thing where I am putting a date in column A, descriptor expense in columnt b, etc.

I would like to find out if I can use some sort of formula where I then get a balance in column E and this keeps adding or subtracting.

EG.

 BALANCE INCOME EXPENSE DATE SOURCE/EXPENSE AMOUNT AMOUNT BALANCE 30/06/2012 Kilkenny Rent 530.00 (\$530) 1/07/2012 Henley Rent 400.00 (\$130)

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

I would like the balance to enter automatically.

Hope someone can help.

Thanks.

Julian

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hi all.

This may seem a simple question but I cant seem to find an answer in help. It all seems to refer to adding rows and not columns.

I am doing a budget type thing where I am putting a date in column A, descriptor expense in columnt b, etc.

I would like to find out if I can use some sort of formula where I then get a balance in column E and this keeps adding or subtracting.

EG.

 BALANCE INCOME EXPENSE DATE SOURCE/EXPENSE AMOUNT AMOUNT BALANCE 30/06/2012 Kilkenny Rent 530.00 (\$530) 1/07/2012 Henley Rent 400.00 (\$130)

<TBODY>
</TBODY>

I would like the balance to enter automatically.

Hope someone can help.

Thanks.

Julian
Shouldn't the balance be positive 130?

Yes. The figure in brackets are indicating that is where I would like to see a balance, positive or negative, but what is the formula to get the balance to show in column E?

Yes. The figure in brackets are indicating that is where I would like to see a balance, positive or negative, but what is the formula to get the balance to show in column E?
Enter this formula in E2:

=IF(C2<>"",C2,IF(D2<>"",-D2,""))

Enter this formula in E3 and copy down as needed:

=IF(COUNT(E2,C3:D3)>1,E2+C3-D3,"")

Hi Valko. Thanks for that. Can you try again with the cells to type in if I give you this info.

Sorry. I am a computer retard.

Thanks.

A B C D E

 1. BALANCE 2. 3. 4. 5. INCOME EXPENSE 6.DATE 7. SOURCE/EXPENSE AMOUNT AMOUNT BALANCE 8. 30/06/2012 Kilkenny Rent 530.00 (\$530) 9. 1/07/2012 Henley Rent 400.00 (\$130)

<tbody>
</tbody>

I havent done that right either.

Imagine ABCDE are in the right places. And as for the rows the blank ones are not there. Just the numbered ones.

Ta.

Julian

I havent done that right either.

Imagine ABCDE are in the right places. And as for the rows the blank ones are not there. Just the numbered ones.

Ta.

Julian
This formula in E8:

=IF(C8<>"",C8,IF(D8<>"",-D8,""))

This formula in E9 then copy down as needed:

=IF(COUNT(E8,C9:D9)>1,E8+C9-D9,"")

I'm assuming this is like a check register with one transaction per row.

Hi again.

Thanks for that it worked. When you say copy down as needed though does that mean I have to put a formula in each cell of column E and change it each time or is there a way I can put a formula in the whole column or copy and paste all the way down some how???

Julian

Highlight as many cells as you want the formula
type in the formula, then press CTRL + Enter

OR
type the formula into the cells as directed by Biff and then look in the bottom RH corner of the cell and drag the little black square down as far as required !

Michael and Biff.

Fantastic. Thanks for your help guys.

Julian

Replies
2
Views
533
Replies
13
Views
497
Replies
16
Views
688
Replies
12
Views
714
Replies
1
Views
388

1,211,869
Messages
6,104,470
Members
447,910
Latest member
abrook1308

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back