Thread: [Solved] using two lookup values to get a sum figur
View Single Post
 
Old 05-18-2015, 06:50 AM
Ian A King Ian A King is offline Windows 7 64bit Office 2013
Novice
  
Join Date: May 2015
Location: England
Posts: 6
Ian A King is on a distinguished road
Angry using two lookup values to get a sum figur
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
Reply With Quote