Team Inventory - If player is inactive how to not count their data

Try to explain my first post best I can.

I have one main page "Player Info" where I grab the data from an online form players fill out. It has more than shown but you can get the idea.

- What I need help in is if one player is "N" (inactive due to sent to lower division, player is signed for next year, etc) I don't want the tabs "GEAR" or "APPAREL" to take their info and count that I need to get a set of 14" gloves for them or apparel for them. So what I am trying to say Player 1 has selected Large, Workout shirt, shorts, tracksuit and polo. The way I have the formulas now it will add his responses to the "How many players in this size" column. I need it to ignore his responses if in "ACTIVE" column he is marked "N" which means he doesn't need the gear this season.

- Sticks are a whole new beast and other tabs extract info from PLAYER INFO columns e:H and I would still like that to happen.

In option 1 I put check boxes but I cannot program so would prefer formulas to VBA.

File attached for reference.

I do have a couple of macros in my file. Thanks in advance if you are able to help.

Thanks all for taking the time to help me out.

Sorry I think I lacked giving you what I am looking for. I am just looking for the sum in column C so I know how many players will need each piece of gear. I was hoping something like this would work but it gives #SPILL

=IF('PLAYER INFO'!A13:A19,"Y")*COUNTIFS('PLAYERINFO'!J:J,"13""") Just gives me a #SPILL. Everything else is manual input as maybe coaches need a pair of gloves so I need to manually input for those things

Appreciate your time..J

Well I figured out how to only count "Y" (active players in the gear count) by using this code. Highlighted in pink in the file.

=COUNTIFS('Player info'!$J$13:$J$18,"13""",'Player info'!$A$13:$A$18,"=Y")

Now my issue is the textjoin I am now using as I like it better than transpose is showing every player's name in that gear (gloves in sample) even if they are inactive in column A. Would anyone know how to fix that formula so only names show up in textjoin that are "Y" active in column A?

Appreciate your help...J

Try this in cell M2:
=TEXTJOIN(", ",TRUE,FILTER(Table4[PLAYER],(Table4[GLOVES]=B2)*(Table4[ACTIVE]="Y"),"No one in this GLOVE"))

You are brilliaint Greg. Sure appreciate your reply. I got it going on my larger team excel sheet after the sample sheet from your formula. This is going to be so helpful.

Thanks again. Stay safe in Georgia Greg. John

You're welcome. Glad it worked for you, eh. :-)