lesker - May 21, 2016 at 12:05 PM

I am trying to sum up the number of times a certain term is found in a spreadsheet and associate it with the number that is at the top of the column for a total score.

I am doing a project that needed to rank the responses and associate them with a total score (i.e if a certain term is mentioned first it gets a score of 25 if second 15 if third 10 if fourth 5 if fifth 1) The sum ifs don't seem to work because the data needs to compare 5 jobs with the top five tools/technology listed(on the horizontal)

any suggestions