Daily Cash Balance

November 14, 2010 at 16:40:13
Specs: Windows 7
Hi,

Could you help me on the following sheet?

Daily Cash Balance: $ 1.000

A B C
ok Pay 300
Pay 150
ok Incom. 400
Incom. 80

My daily cash flow must be update only when the column A is set OK. Those rows had been added days, weeks or months ago, however when I'll finish the day I would like to see the Balance: $1.100. I have to translate the formula below to a Excel formula:

If column B = pay and column A = OK then Balance - Column C
If column B = Incom. and column A = OK then Balance + Column C

Thanks a lot


See More: Daily Cash Balance

Report •

#1
November 14, 2010 at 17:19:45
The table above is not clear... so, just to don't be confused, let's try again:
containt on column A: ok or null;
containt on column B: Pay or Incom.
containt on column C: amount

A B C
ok Pay 300
null Pay 150
ok Incom. 400
null Incom. 80


Report •

#2
November 14, 2010 at 17:38:56
If your using Excel 2007 then the =SUMIFS() function should get you what you want.

If your data looks like this:

     A          B             C
1)           Balance     $1,000.00
2)
3) ok        Pay           $300.00
4)           Pay           $150.00
5) ok        Incom.        $400.00
6)           Incom.         $80.00
7)
8)                       $1,100.00

Then this formula in Cell C8 should get you what you want:

=SUMIFS(C3:C6,B3:B6,"Incom.",A3:A6,"ok")-SUMIFS(C3:C6,B3:B6,"Pay",A3:A6,"ok")+C1

MIKE

http://www.skeptic.com/


Report •

#3
November 15, 2010 at 05:37:46
Cheers MIKE!!!

I'm using 2010 version but works perfectly.

Thank you very much.


Report •

Related Solutions

#4
November 15, 2010 at 06:47:22
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Ask Question