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. 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 C

If column B = Incom. and column A = OK then Balance + Column CThanks a lot

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 C

ok Pay 300

null Pay 150

ok Incom. 400

null Incom. 80

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.00Then 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

Cheers MIKE!!! I'm using 2010 version but works perfectly.

Thank you very much.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History