SUM COUNTIF FORMULA HELP

[rikvny02]

short version - I can't get the below formula to work. Its an easy fix but its just not coming to me. I am trying to keep track of Win/Losses for the season. Thanks for any help you can provide.

If column J matches column C, I'd like the count of losses in column D.

example:
CELL L6 =sum(countif(c4:c19,j3,d4:d19 = "L"))

yes I'm aware I should use the XL2BB, unfortunately I can't download it from my current location.

 

[rikvny02]

I figured it out.

The team names did not match exactly. All the names in column "C" had a space at the end. Clean(trim) solved my issue. Thanks for the help
@Fluff @dreid1011

 

[Fluff]

Glad you sorted it & thanks for letting us know.