Calculating total of certain values in column X based on set category defined in column Y

Dear all,

I need some suggestions / help as to who I can calculate the total value of some cells in "Column X" based on a pre-defined critera found in "column Y".

The scenario is that I have a long transaction list - sorted on date - where each transaction is categorized as to the source of the transaction (e.g. ticket sales, donations etc.). I then want to sum all transaction categorized as "ticket sales", "donations" and so on, in order to have control over how much we have in income from the different sources. The categorie is defined in column D while the value can be found in column E.

In advance, thank you for any help.

Karsten

Hi Glenn,
While in the process of making the mock workbook, I actually found the solution by getting the SUM.IF -function to work.

Have a nice day!