Adding columns A and B to get a result in C

[JulianMS]

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

 

[T. Valko]

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?

 

[JulianMS]

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?

 

[T. Valko]

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,"")

 

[JulianMS]

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>

 

[JulianMS]

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

 

[T. Valko]

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.

 

[JulianMS]

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

 

[Michael M]

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 !

 

[JulianMS]

Michael and Biff.

Fantastic. Thanks for your help guys.

Julian