How to sum data based on a unique identifier

**tommypkoch** · 02-24-2015, 11:53 AM

I would like for the program to list each unique identifier from column b in column c (one time) and then show the sum of the data associated with the identifier from column C in column F. I could do it with IF statements if the identifiers stayed the same each time but they can vary, they are not always letters and more commonly are a unique set of letters and or numbers, changing daily.

The sumtotal function works but is cumbersome due to the large amount of data and the need to copy the sums over to a new tab using visible cells only.

Any help is greatly appreciated!

**AlKey** · 02-24-2015, 11:58 AM

Use this formula in E3 and copy down

=IFERROR(INDEX($B$2:$B$9,MATCH(0,INDEX(COUNTIF(E$2:E2,$B$2:$B$9),,),)),"")

and SUMIF in F3 and copy down

=SUMIF($B$2:$B$9,E3,$C$2:$C$9)

**tommypkoch** · 02-24-2015, 08:54 PM

Thanks you! Works like a charm.

**AlKey** · 02-24-2015, 09:05 PM

Thank you for the feedback!

**tommypkoch** · 02-24-2015, 09:10 PM

Solved by AlKey

How to sum data based on a unique identifier

LinkBack

Thread Tools

Rate This Thread

Display

How to sum data based on a unique identifier

Re: How to sum data based on a unique identifier

Re: How to sum data based on a unique identifier

Re: How to sum data based on a unique identifier

Re: How to sum data based on a unique identifier

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need to copy data cells from one sheet to another based on unique identifier

Merging Rows on a Unique Identifier while Keeping Unique Data and Adding Values Together

[SOLVED] Take column data from one sheet to another based on unique identifier

Combine rows of data into 1 cell based on unique identifier

Formula to return a unique identifier to a row of data based on 2 columns?

Bookmarks

Bookmarks

Posting Permissions