# 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.000A B Cok Pay 300 Pay 150ok Incom. 400 Incom. 80My 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 CIf column B = Incom. and column A = OK then Balance + Column CThanks a lot

See More: Daily Cash Balance

#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: amountA B Cok Pay 300null Pay 150ok Incom. 400null 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")+C1MIKE

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