Adding amounts under certain critera

[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.

[southward]

Hi Marvo,

I think what you are looking for is a SUMIF or SUMIFS.

I could help provide a better answer if you were to upload a sample file of what you are working on.

Cheers

[kbdavis]

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.

[Marvo]

Post no longer needed.

[Marvo]

That's done it KBdavis. Thank you both so much for your help and taking an interest.