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
Bookmarks