Adding columns A and B to get a result in C

JulianMS

New Member
Joined
Jun 28, 2012
Messages
6
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
DATESOURCE/EXPENSE AMOUNT AMOUNT BALANCE
30/06/2012Kilkenny Rent 530.00
($530)
1/07/2012Henley 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?
 
Upvote 0
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?
 
Upvote 0
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,"")
 
Upvote 0
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.
INCOMEEXPENSE
6.DATE
7.
SOURCE/EXPENSE
AMOUNTAMOUNTBALANCE
8. 30/06/2012
Kilkenny Rent530.00($530)
9. 1/07/2012
Henley Rent400.00($130)

<tbody>
</tbody>
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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 !
 
Upvote 0

Forum statistics

Threads
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?

Disable AdBlock

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