Hi,

I seem to be having difficulties with a very simple formula!

ITEM A
Cost A = B6
Outstanding Balance = C6

ITEM B
Cost A = B7
Outstanding Balance = C7

So, if a payment was entered as below:

(A) (B) (C) (D)
Date Paid Amount Method
19/10/2016 ITEM A £350.00 Cash
19/10/2016 ITEM A £300.00 Card
28/10/2016 ITEM B £50.00 BACS

I thought it would be something like =IF(B13:B100="ITEM A",B6-C13:C100,"")

Any help is appreciated!