How to Sum across duplicates (not using pivot tables)

**derrickk** · 07-12-2013, 01:58 PM

Hi All,

I'm working with a large data set that has Facility, Owned by, Ownership share (%), Production in units. I'm trying to aggregate total output by facility across multiple owners. I can't use a pivot table because this is a subset of a larger dataset (that I need to keep structurally intact). I've attached a sample workbook, essentially I'm trying to find a formula to put in column E. Basically each plant can potentially have multiple owners (shared ownership) with output listed by ownership share. I want to aggregate across all owners to have plant level output.

I think I can probably do this using sum-ifs, I'm just not sure what the syntax would be.

example.xlsx
Any help is greatly appreciated!

Thanks!

**oeldere** · 07-12-2013, 02:11 PM

With sumif.

I (strongly) advice you use an pivot table (also added in your file).

**derrickk** · 07-12-2013, 02:23 PM

Thanks for the quick reply! I would normally use a pivot, but I've got over 90 columns of data and I need to retain the format of the data, as it's an input file to a broader model....

Come to think of it, I could have come to the same result by pivotting and VLOOKUP'ing the pivot.

Cheers,
Derrick

**oeldere** · 07-12-2013, 02:30 PM

The pivot table can also be added on a differant sheet (if that was a problem for you).

But you can use all columns in a pivot table (but it is not neccesary).

You can also make an pivot table of a part of the file (e.g. column C til F).