Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up values with multiple criteria
I have 3 columns(department, date and wage hours) the department and the
dates repeat so that it states: Maintenance 7/5/08 41 Warehousing 7/5/08 37 Maintenance 7/10/08 48 Warehousing 7/10/08 28 At the beginning of each new date it starts the departments over again. I need to organize the info so that there the dates and departments are not repeating. The end product needs the dates across the top row and the four different departments on the left column with the wages fulling the data area. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up values with multiple criteria
Suppose your data is on Sheet1, occupying A1:C100. Insert a new sheet
and put your dates in row 1 starting with B1 and put your 4 departments in column A starting with A2, so that you have something like this: 7/5/08 7/10/08 and so on ... Maintenance Warehousing etc ... Then in B2 you can put this formula: =SUMPRODUCT((Sheet1!$A$1:$A$100=$A2)*(Sheet1!$B$1: $B$100=B$1)*(Sheet1! $C$1:$C$100)) (adjust the ranges to suit your data). Copy the formula down into B3:B5, then copy B2:B5 across for as many dates as you have. Hope this helps. Pete On Jun 24, 10:32*pm, CodyT wrote: I have 3 columns(department, date and wage hours) the department and the dates repeat so that it states: Maintenance * * * * * 7/5/08 * * * * 41 * Warehousing * * * * *7/5/08 * * * * 37 Maintenance * * * * * 7/10/08 * * * 48 Warehousing * * * * *7/10/08 * * * 28 At the beginning of each new date it starts the departments over again. *I need to organize the info so that there the dates and departments are not repeating. *The end product needs the dates across the top row and the four different departments on the left column with the wages fulling the data area. * Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
How to retrieve multiple values in multiple rows with one criteria | Excel Discussion (Misc queries) | |||
Calculating values from multiplesheets with multiple criteria | Excel Worksheet Functions | |||
Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
how do i count values based on multiple criteria | Excel Worksheet Functions |