try this formula:
Formula: copy to clipboard
=SUMIF(C3:C24,"Brendan NHL",K3:K24)

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