Forum Discussion
Formula to search names with numbers next to them and add
Cant find a configuration to Sum up Names with numbers next to them. My list goes like: joe 1 joe 1 jim 1 jim 1 And so on. I need to just take all instances of "joe 1" and add the numbers so...
Cujo5 It seems you are just trying to count each unique name. Formula I have used as per screenshot.
B2=LEFT(UNIQUE(A2:A6),SEARCH(" ",UNIQUE(A2:A6)))
C2=COUNTIFS(A2:A6,"*"&B2#&"*")
