CuriousMike
Diamond Member
I need some help figuring out how to sum a range of values.
It's hard to visualize the data, but I get an unsorted list of items like this:
ColA is a list of names, ColB is a list of values.
ColA-ColB
Name-Wins
bob-5
tom-1
edd-2
bob-1
edd-1
edd-1
edd-1
bob-1
tom-6
edd-8
bob-7
tom-9
edd-1
1. I sorta column A alphabetically.
2. I find all unique elements using Filter->Copy To Another Location->Unique Records Only
This ensures I have a new column of (in this case) only 3 entries, Edd Bob and Tom.
3. I countif each time I see entries of my unique guys. So my new sheet looks like:
Name-Instances
bob-4 (there are 4 instances of bob)
edd-6 (there are 6 instances of edd)
tom-3 (there are 3 instances of tom)
4. This is where I'm stuck. I want to be able to add all the original column B values associated with each so I have a total.
The table looks like this:
Name-Wins
bob-2
bob-3
bob-1
bob-5
edd-2
etc etc. I now know that bob has 4 entries (per step 3), but I still can't figure out how to create unique sums for each of my unique entries.
It's hard to visualize the data, but I get an unsorted list of items like this:
ColA is a list of names, ColB is a list of values.
ColA-ColB
Name-Wins
bob-5
tom-1
edd-2
bob-1
edd-1
edd-1
edd-1
bob-1
tom-6
edd-8
bob-7
tom-9
edd-1
1. I sorta column A alphabetically.
2. I find all unique elements using Filter->Copy To Another Location->Unique Records Only
This ensures I have a new column of (in this case) only 3 entries, Edd Bob and Tom.
3. I countif each time I see entries of my unique guys. So my new sheet looks like:
Name-Instances
bob-4 (there are 4 instances of bob)
edd-6 (there are 6 instances of edd)
tom-3 (there are 3 instances of tom)
4. This is where I'm stuck. I want to be able to add all the original column B values associated with each so I have a total.
The table looks like this:
Name-Wins
bob-2
bob-3
bob-1
bob-5
edd-2
etc etc. I now know that bob has 4 entries (per step 3), but I still can't figure out how to create unique sums for each of my unique entries.
