Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-18-2015, 06:50 AM
Ian A King Ian A King is offline using two lookup values to get a sum figur Windows 7 64bit using two lookup values to get a sum figur Office 2013
Novice
using two lookup values to get a sum figur
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
using two lookup values to get a sum figur Lookup / Paste Multi Values VBA Mav Excel Programming 6 05-10-2015 08:42 PM
Lookup multiple values and compare different scenarios to get a specific result mws Excel 5 05-24-2014 04:52 AM
How can match or lookup values from two separate tables? klawk26 Excel 1 07-31-2012 09:04 PM
using two lookup values to get a sum figur Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
using two lookup values to get a sum figur LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft