Excel formula, text in column to a value

I have a column in my excel spreadsheet that has a name entry, e.g D1 = Tony, D2 = Fred, D3 = Gordon, etc. The names can appear in the same column more than one, e.g Tony appears say 5 times, Fred 2 times and Gordon 4 times.

I need a formula that will take the values of Tony and Fred in the column D, and calculate the value the total (=6).

I can use the formula =COUNTIF(D1:D10,”Fred”) and this will give me 2, but I really need to say give me the total of Tony and Fred?

Not being an expert with excel I’ve run out of ideas?