Count the times a specific character appears next to a name

lre712

New Member
I have a list of names in column K, and letters in columns L-M.

The name appears multiple times in column k, I would like to know the sum of letters against each name for col L-K

e.g

My name | A, B, C, D
My name| A, D
Your name| A, B, C, D

thanks
Lee

lre712

New Member
I would like to know the sum of each character in col b-e based on the names in col A. Note that some names appear twice.

Attachments

• 9.5 KB Views: 6

bosco_yip

Excel Ninja
1] Put character "S", "O", "C" and "D" in the header of range H1:K1

2] In H2, formula copied across to K2 and all copied down :

=SUMPRODUCT((\$B\$2:\$E\$17=H\$1)*(\$A\$2:\$A\$17=\$G2))

Regards
Bosco

Last edited:

lre712

New Member
1] Put character "S", "O", "C" and "D" in the header of range H1:K1

2] In H2, formula copied across to K2 and all copied down :

=SUMPRODUCT((\$B\$2:\$E\$17=H\$1)*(\$A\$2:\$A\$17=\$G2))

Regards
Bosco
Thank you, that did the trick.