Adding amounts under certain critera

I have an accounts workbook.

Column D lists actions, such direct debit, standing order, etc, Column E list the amount, either + or -.

I'd like a formula that adds all the amounts that appertain to one action, in this case interest accrued.

I'm guessing it would be an IF statement, such as IF column D = interest then add the amount in column E to give me a total amount of interest accumulated over a given span of time.

I can't get my head round the formula needed.

Any help greatly appreciated.

Originally Posted by Marvo

I have an accounts workbook.

Column D lists actions, such direct debit, standing order, etc, Column E list the amount, either + or -.

I'd like a formula that adds all the amounts that appertain to one action, in this case interest accrued.

I'm guessing it would be an IF statement, such as IF column D = interest then add the amount in column E to give me a total amount of interest accumulated over a given span of time.

I can't get my head round the formula needed.

Any help greatly appreciated.

I am assuming column D will show the word "interest", and E is the amount of interest?

If so, try

Please Login or Register  to view this content.

Post no longer needed.