How can I consolidate rows with same names but sum up only certain columns?

**bottledwater** · 07-14-2016, 04:23 PM

Hi there,

I have a sheet with a list of sales reps and their sales. Some of them have multiple entries because they are active in different cities.
I need to combine these entries but only sum up certain columns (see sample sheet) so that there is only one row per sales rep with only columns D and E summed up since F and G stay the same.

How do I do that?

**FlameRetired** · 07-14-2016, 05:36 PM

In the attached:

I copied and pasted all Sales rep in column I.
Then applied Remove duplicates.
In J2 this formula filled down until you get blanks and across to column O
Formula:
```
Please Login or Register  to view this content.
```
Then overwrote that formula in in L2 filled down until you get blanks and across to column M.
Formula:
```
Please Login or Register  to view this content.
```

How can I consolidate rows with same names but sum up only certain columns?

LinkBack

Thread Tools

Rate This Thread

Display

How can I consolidate rows with same names but sum up only certain columns?

Re: How can I consolidate rows with same names but sum up only certain columns?

Thread Information

Users Browsing this Thread

Similar Threads

Consolidate Data In Multiple Rows and Columns Into One Row

[SOLVED] Consolidate multiple rows that have similar names into one row in another workbook

Consolidate multiple columns and rows into one Column

[SOLVED] Consolidate text data from rows into columns

[SOLVED] Help! Need to consolidate rows and manipulate unique data into columns at rows' end

consolidate rows with the same ID# but different columns

How do I chage/eliminate the names of the columns and rows

Bookmarks

Bookmarks

Posting Permissions