Question: Count Phrase in one Column, and Sum another
Hoping you can help with this. I have this kind of data:
|Song 1 Test||2.58|
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.