Hi All

Below is a list of transactions for month from a company credit card:

A B
1 Expense A/C Amount
2 3030 - Advertising 75.00
3 3090 - Consultancy Fees 150.00
4 3260 - Motor Vehicle Expenses 200.00
5 3290 - Printing & Stationery 123.60
6 3260 - Motor Vehicle Expenses 150.00
7 3131 - Entertainment Client 50.00
8 3131 - Entertainment Client 22.00
9 3260 - Motor Vehicle Expenses 15.00

What I am looking to do is get everything totalled for each expense as below so I can get a monthly total:

A B
Expense Total
12 3030 - Advertising
13 3090 - Consultancy Fees
14 3260 - Motor Vehicle Expenses
15 3131 - Entertainment Client
16 3290 - Printing & Stationery

Is this done using a SUMPRODUCT formula of SUMIF with a VLOOKUP array inside it?

Does the setup of the formula matter if the expense a/c is allocated via a data validation list?

Apologies if the setout isn't perfect - first time posting in the forum.

If some guidance can be provided that would be much appreciated.