Count Phrase in one Column, and Sum another
Hello -
Hoping you can help with this. I have this kind of data:
Title | Royalty |
---|---|
Song 1 | .56 |
Song 1 | 2.36 |
Song 3 | 1.25 |
Song 1 Test | 2.58 |
song 2 | .25 |
Song 5 | .78 |
Song 1 | 5.23 |
and so on. What I want to do is sum up the royalties for each song, (an added bonus would be to use a wild card so that in my above example, it would count Song 1 and Song 1 Test as the same song). I am doing this in a separate table, but I don't think that matters that much, as I know how to reference other cell in other tables.
I tried finding a formula like this from excel: =INDEX($A$1:$A$16,MODE(MATCH($A$1:$A$16,$A$1:$A$16,0))) but it doesnt work and searching around here I have found that Numbers doesn't do this formula like Excel Does. So, I know there is an answer, but I can't find it.
Thanks - as always- for the help.
Cheers
kc