Look up person and count W's and L's

Jtempleman

New Member
Joined
May 30, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have created a bracket for a pool tournament that randomizes each round. A win (w) or loss (I) is entered next to the players name. I am trying to see if there is a formula to lookup a player name for the entire range of rounds and count the number of "w" and "l" entered in the Wins and Loss columns. For example, the formula would look up Amanda and count how many W's there are next to her name. I cannot get the mini sheet add in to work and the full pic of the worksheet was too large. I was only able to pic a portion of the file.
 

Attachments

  • Screenshot 2023-12-14 195646.png
    Screenshot 2023-12-14 195646.png
    63.5 KB · Views: 10

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Welcome to the Forum!

One way you could do this:

ABCDEFGHI
1
2Round 1Round 2Round 3Round 4
3
4ChrisWChrisLAmandaW
5AmandaW
6ChrisLAmandaW
7AmandaL
8ChrisL
9
10Wins
11Amanda3
12Chris1
13
Sheet1
Cell Formulas
RangeFormula
C11:C12C11=COUNTIFS(B$3:H$8,B11,C$3:I$8,"W")
 
Upvote 0
Or try:

Book1
ABCD
1
2Round 1Round 2
3
4ChrisWAmanda
5AmandaWJohn T
6John TLAmanda
7AmandaWJohn T
8AmandaLChris
9
10Wins
11Amanda3
12Chris2
13John T0
Sheet1
Cell Formulas
RangeFormula
C11:C13C11=COUNTIFS($B$4:$B$8,B11,$C$4:$C$8,"W")+COUNTIFS($D$4:$D$8,B11,$C$4:$C$8,"L")
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top