(no subject)

[nonethefewer]

There may be a better way to do this, but whatever.

In Excel, I have column A, which shows all amounts, and column B, which shows the date the transaction was cleared.  (Mmm, banking.)  I wanted to show a total of what had not yet cleared.

So.

=Sum(A:A) - SumIf(B:B, "<>", A:A)

Comments

[underwatercolor.livejournal.com]

Forgive the randomness, but I <3 arrayformula() recently. :)