In the array below i need to use a formula in col D to Sum the total for DMC shown in Col A
is this at all possible, if so how. I need this for a another table which will have only one category unit i.e Airport, Client Costs J$J, Contingency, DMC, Guides and show results of column D
Thank you

A B C D
Airport Transfers 700 700
Client Costs J&J Events 4800 4800
Contingency Fees 1000 1000
DMC Dinners 500 2850
DMC Gratuities 50
DMC Handling Fees 250
DMC Lunches 50
DMC Salary 2000
Guides Single 200 200

Please post a sample sheet. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

As per your request

Attached Files

Samle Budget.xlsx (11.2 KB, 10 views)

=sumif(A:A,"DMC",C:C)