Counting Hearts

KLP

We are using a sheet to rate name suggestions. Each employee has their own column and they rate each name suggestion using the heart scale. Does anyone know how to count/sum the total numbers of hearts in a row? Example: I rate a name ❤️❤️❤️❤️❤️, someone else rates it ❤️❤️ - That name suggestion would have a rating of "7".

Thank you!

John Jonassen

I think it may be too complex to get it into a single column. So maybe 6 columns following the Heart column, heading them as "One", "Two", "Three", "Four","Five", and "Total"

Then your formulas will be as follows:

One: If(Heart1="One",1,0)*1

Two: If(Heart2="Two",1,0)*2...etc up to five. Then the "Total" would be the sum going across the row. Then you can do a Parent Child for each rate name suggestion to do a roll up of each rating and grand total scores.