• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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
Your name| A, C
My name| A, D
Your name| A, B, C, D

thanks
Lee
 

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:
Top