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.

 

[dreid1011]

Did you retype that formula or copy and paste? If you copied it directly, then the first thing I can see is your formula has J3 when it should be J4? And for multiple criteria, you should probably be using COUNTIFS instead of COUNTIF.

 

[Fluff]

If the formula is in L6 shouldn't it be looking at J6 rather than J3?
Also there is no need to wrap it in SUM.

 

[rikvny02]

If the formula is in L6 shouldn't it be looking at J6 rather than J3?
Also there is no need to wrap it in SUM.

you are correct. typing mistake. J6 is the correct cell reference

 

[Fluff]

Does that then work?

 

[rikvny02]

Does that then work?

no, it states I have too few arguments.

 

[dreid1011]

you are correct. typing mistake. J6 is the correct cell reference

Does that then work?

If that does not work, perhaps this in L4 copied down:

=COUNTIFS($C$4:$C$19,J4,$D$4:$D$19,"L")

 

[rikvny02]

If that does not work, perhaps this in L4 copied down:

=COUNTIFS($C$4:$C$19,J4,$D$4:$D$19,"L")

the above formula is returning 0. which we know is not true because in cell D4 it shows "L". This was the reason I tried the = sign

 

[Fluff]

Did you drag the formula from L4 down to L6?

 

[rikvny02]

Did you drag the formula from L4 down to L6?

I did not drag the formula. I entered it only into L6 as I would expect a result. (1)
L6 =COUNTIFS($C$4:$C$19,J6,$D$4:$D$19,"L")