How do I add a list of names to a spreadsheet and each time a specific name appears add the number 10 to cell. For example, I would put a name like Jones in A1 then Jones in A5. And in D5 it would have the number 20. If I then add Jones in B2 then D5 would say 30. Add 10 each time Jones appears.
What formula would I use?