Be Excellent To Each Other

Evening all!

I'm trying to knock up an Excel spreadsheet to help monitor my finances, but I'm not all that proficient with it and could use a quick point in the right direction.

Essentially, I want to be able to enter a transaction into the spreadsheet and have the sheet automatically give me a running total, but only if that transaction has actually cleared.

So, lets say the transaction amount is in cell 1 of each row, a simple Y/N to denote whether the amount has cleared or not in cell 2 of each row and the running total in cell 3 of each row.

So I want cell 3 to get automatically populated by the sum of cells A3 and B1, but only if B2 = Y. Otherwise, I want cell B3 to have the same value as cell A3.

Does this make any sense at all?

So what's the formula I need to pull this off?

Thanks!

It's doable by a formula, but easier would be to have a cleared funds column and a pending funds column, then instead of putting a Y in a column, just move the value to the cleared column. Then just sum the cleared column.

=if (b2="y", a3+b1, a3)
Might need speech marks though around the a3+b1 and a3 bit
Top tip: click the fx in the formulae bar and it bringd boxes up to hrlp

Craster - that's one of those "why the fuck didn't I think of that?" type things, so good suggestion.

However...

MailA - that formula works perfectly, thank you!

"we bought it to help with the homework /
And the household accounts /
If your dad ever /
figures it out"