I'm looking to do what as far as I know is a straight forward enough task in excel...............just can't think the best way of doing it!!
I am taking registrations for a course and I have two columns (K&L) for paid and fee
Column L is the fee that the person is due to pay and at the bottom of the list the total amount taken in is added together to give me the "Monies in (Expected)" total
However what I am trying to do in row K is make a total of "Monies in (paid)"
To do this I need a formula that will see text in a cell and then take the value of the cell beside it to add to the total............ for example:
Cell L1 = €50, L2 = 55, L3 = 60
The total for monies in expected will be €165, but if only K1 and K3 have "Paid" in the cell it means that the money already paid will only be €110
So if any Cell in column K has text "Paid" in it the formula should sum all values that are in Column L in the same row
I'm not sure that all makes sense, hopefully it does!
Look forward to your response