If value is true add cell to the right...

Any time a cell A$ (or A2 till A45 ect...) = John Smith, add cell to the right

This will have to be done for MANY cells and it won’t make sense to type out long stings of code like the one below. The code below does do what I want, but there must be a simpler way

Code is E2
=IF(A1=D2,B1,0)+IF(A2=D2,B2,0)+IF(A3=D2,B3,0)+IF(A4=D2,B4,0)+IF(A5=D2,B5,0)+IF(A6=D2,B6,0)

A---------------------B-----C--------D-------------------E
1 John Smith-----4--------------Totals
2 John Smith-----2--------------John Smith------14
3 Jane Doe--------5--------------Jane Doe---------16
4 John Smith-----8
5 Jane Doe--------6
6 Jane Doe--------5