Formula to count the last 5 specific text entries in a column

[zooter23]

Hi everyone!

First time poster here. Is there a formula to count the last 5 specific text entries in a column? I am creating a spreadsheet to track statistics for my son’s baseball team and would like to count their “Last 5” wins. While I’ve found a way to do this by recording wins and losses in adjacent columns, using 1 or 0 [e.g., =SUM(OFFSET(C3,COUNT(C3:C17)-5,,5))], I would like to use a single column and enter only “W” or “L”.

Thanks so much for your help!

[kev_]

Try this

=COUNTIF(OFFSET(B3,COUNTA(B3:B17)-5,,5),"W")

[zooter23]

Thank you! I found a lot of different "suggestions" for this and none have worked until now!

[Pete_UK]

I don't know much about baseball, but is it not possible for the two teams to draw the match?

Pete

[kev_]

win, lose or draw...
... if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED- Thanks

[zooter23]

I don't know much about baseball, but is it not possible for the two teams to draw the match?

Pete

Pete_UK, normally baseball games are played until there is a winner, but kid's games can end in a tie as we can't let them play all night (as much as they'd want to)! Now that I have a working formula, I can adjust it to include losses and ties.

[zooter23]

win, lose or draw...
... if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED- Thanks

Thanks again! I was wondering how to do that.