How do I total only specific values in a column based on the values in another column

I am trying to get this idea translated to excel and have been unsuccessful thus far:

This is what I tried "IF(D:D="JOHNNY",SUM(H:H)), How do I make it total only the values in H that are associated with Johnny?

If D does equal Johnny I want it to total all of the numeric values in column E that correspond to Johny and if not I want it to disregard the value in E. I either get 0 or it gives me the total of all values in the E column. I want all of Johnny's numbers to total in one place, all of Susie's in another and so on.

I know that filtering and sorting is the easy route but I would really like to get this to work so I can stop filtering and sorting and revising the formula, I want the totals to be automatic so I can input the data and see the result.

Welcome to the forum

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search.

Try SUMIF

e.g =Sumif($D$1:$D$100="Johnny",$E$1:$E$100)