How to match name with number between two different columns then sum the numbers?

[kelvinvu12]

Book1.xlsx

Hello,

As seen in the worksheet provided, I'm wondering how I can sum the numbers in the K column if the C column has "Brendan NHL" written in it and so forth for "Valdemar NCAAB". The worksheet provided will provide much more information.

Thanks for any help! Greatly appreciate it!

[jewelsharma]

try this formula:

=SUMIF(C3:C24,"Brendan NHL",K3:K24)

Simply replace "Brendan NHL" with "Valdemar NCAAB" to get the other value.

[FDibbins]

As suggested, sumif() is the way to go for this. If you have a list of names, you can reference them instead of hard-coding...

	M	N
3	Brendan NHL	17.18991
4	Valdemar NCAAB	3.052984

N3=SUMIF(C:C,M3,K:K)
copied down