EXCEL FORMULA

[jatolo]

AMOUNT PYMT
$300.00 Ch# 2343
$2,000.00 $0.00
$45.00 Ch# 2346
$70.00 Conf.# 4563
$3,455.00 $0.00

$5,870.00

Can anyone help me, please.
I'm trying to "write" this FomulA, to have a balance but.... I giving up....
=IF(B2:B6<>0,C8-(SUM(A2:A6))

Thanks for your help....

 

[ThomasLafferty]

Take a look at Tools>Conditional Sum. If that won't do it for you, take a look at the SUMPRODUCT function.

Hope this helps.

Tom

Born once die twice; born twice die once.

 

[firefytr]

Can you post where your data is being housed and write out the logic of what you want returned? It's not too evident from your post. Also take a look at the TGML tags you can use for the board, take note of the tt tags.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[AnotherHiggins]

jatolo,

What exactly are you trying to do? It seems like you just want to make something like a check book registry, where you have deposits and debits and you want to keep a running balance. Is that right?

If so, then generally you would just do something like this:
[tt]
A B C D
1| Date Deposit Debit Balance
2| Start $1,000.00
3| 08/01/06 $250.00 [red]$750.00[/red]
4| 08/02/06 $100.00 [red]$850.00[/red]
5| 08/03/06 $75.00 [red]$775.00[/red]
6| 08/04/06 $325.00 [red]$450.00[/red]
7| 08/05/06 $50.00 [red]$400.00[/red]
8| 08/06/06 $300.00 [red]$100.00[/red]
9| 08/07/06 $100.00 [red]$200.00[/red]
10| 08/08/06 $500.00 [red]($300.00)[/red][/tt]

where the formula for the red values above is (starting in cell D3) is [COLOR=blue white]=D2+B3-C3[/color].

Then just fill the formula down the column.

If that isn't what you're after, you will need to provide a lot more detail about what is in the cells used in your formula and what it is you want to do.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[jatolo]

I'm sorry guys, I've should explain it.

AMOUNT PYMT
$300.00 Check# 2343
$2,000.00 $0.00
$45.00 Check# 2346
$70.00 Confirmation.# 4563
$3,455.00 $0.00

$5,870.00 .......?????

What I'm looking for is to show THE CURRENT BALANCE in cell B8. Every time I make a Payment I want it to be reduced from A8. 0 means that I have NOT make pymt yet...

A8-A2 ($300)
A8-A3 NO PYMT
A8-A4 ($45)
A8-A5 ($70)
A8-A6 NO PYMT
THE CURRENT BALANCE SHOULD BE $5,455.00
=IF(B2:B6<>0,A8-(SUM(A2:A6))

Thanks again

 

[keun]

$0.00
$300.00 $0.00 Check# 2343
$2,000.00 $2,000.00 0
$45.00 $2,000.00 Check# 2346
$70.00 $2,000.00 Confirmation.# 4563
$3,455.00 $5,455.00 0
$5,455.00

CURRENT BALANCE = $5,455.00

Insert a Column between your two columns. Also put a 0 in B2. Leave ROW 1 BLANK, except for a "0" in B2 (this 0 is not necessary)

Put this function in the cells in the middle column:
=IF(ISNUMBER(C2),A2+B1,B1)

 

[firefytr]

If those are either 0 (zeros) in B2:B7 and otherwise you have text (check#, etc), then you can use something like ...

=SUMIF(B2:B7,0,A2:A7)

Hope I understood you alright. Although I would recommend something like John (anotherhiggins) has shown.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[SkipVought]

[tt]
B8: =A8-SUM(A9:A65536)
[/tt]
assuming that your payments in in column A beginnig in row 9

Skip,

_[red][/red]