Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT DUPLICATES
I am having issues with duplicating lines of info i am currently using a
SUMPRODUCT and and INDEX function but can n ot seem to get it to work acurately. Current Data EQ# Cost Code Hours 1 2.2.200 1 3.2.710 4 1 3.4.700 3 1 3.4.710 5 1 3.4.710 6 1 3.4.710 5 1 3.4.710 2 1 3.4.710 2 1 3.4.710 2 1 3.4.710 8 1 3.4.710 7 1 3.4.710 8 1 3.4.710 7 1 3.4.710 6 1 3.4.710 4 1 3.4.710 6 1 5.2.100 5 I would like to go to a second sheet put in 1 eq number and have it populate the cost codes and sum of hours within those cost codes without duplicating cost codes and hours. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT DUPLICATES
Hi,
I'm struggling to understand the relevance of 1 in the EQ# column because everything is 1. To sum cost codes from another sheet simply use =SUMPRODUCT((Sheet1!B1:B17="3.4.710")*(Sheet1!C1:C 17)) In practice I'd use a cell reference for "3.4.710" Mike "GSemler" wrote: I am having issues with duplicating lines of info i am currently using a SUMPRODUCT and and INDEX function but can n ot seem to get it to work acurately. Current Data EQ# Cost Code Hours 1 2.2.200 1 3.2.710 4 1 3.4.700 3 1 3.4.710 5 1 3.4.710 6 1 3.4.710 5 1 3.4.710 2 1 3.4.710 2 1 3.4.710 2 1 3.4.710 8 1 3.4.710 7 1 3.4.710 8 1 3.4.710 7 1 3.4.710 6 1 3.4.710 4 1 3.4.710 6 1 5.2.100 5 I would like to go to a second sheet put in 1 eq number and have it populate the cost codes and sum of hours within those cost codes without duplicating cost codes and hours. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT DUPLICATES
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Duplicates | Excel Discussion (Misc queries) | |||
SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions |