| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup and sum of multiple lines
I am importing productivity data from our pos system into worksheet A and
trying to use it to sum up some totals per employee and put it in worksheet B to calculate commission. I would like to do a lookup for the employee and then add up his totals for(in this example) air filters and Breathers. So the lookup should return 25.98 for DUMA,ABE or 21.98 for DAVIS,AL. Is this possible with lookups and sums? column A column B Employee: DUMA,ABE Average Time Per Car Item ================== TOTAL INVOICES 7 CUSTOMER VISITS: ****************** LUBE ONLY: ****************** AIR FILTERS: 14.99 BREATHER FILTERS: 10.99 Employee: DAVIS,AL Average Time Per Car Item ================== TOTAL INVOICES 12 CUSTOMER VISITS: ****************** LUBE ONLY: ****************** AIR FILTERS: 7.99 BREATHER FILTERS: 13.99 -- Thanks Roch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
| display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
| Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
| vlookup with multiple lines of same value | Excel Worksheet Functions | |||
| Multiple blank lines, between multiple lines | Excel Programming | |||
Threaded Mode
