Inventory if date added to sheet look for size and add results to another sheet

[GolfNut39]

Afternoon.

On the spreadsheet attched this is what I am trying so desperately to do.

If a player receives a new W/O (Workout) Shirt I manually go into the "INVENTORY OUT" tab and put in a date I have given it to them.

My goal would be to have a formula in "APPAREL INVENTORY" tab In the "HANDED OUT" Column that would look in the "INVENTORY OUT" tab for a date and then look to the column to the left and count how many say medium W/O shirts were handed out so I could minus that from my inventory

So if I wasn't clear. Here is my example.

- Player ONE had a workout shirt given to him on 29 Apr 21 (manually put in to INVENTORY OUT tab) One day dream of a Userform doing this for me. so my goal would be to have tab APPAREL INVENTORY, HANDED OUT column cell I6 automatically put a 1 in there as one has been handed out.

- Now it should add player 7 and PLAYER 12 who has the same size shirt handed out so should now be 3 in tab APPAREL INVENTORY, HANDED OUT column cell I6

- Same thing PLAYER 13 with size XXL tab APPAREL INVENTORY, HANDED OUT column cell I8.

Thanks in advance for any help you can provide. Stay Safe!

John

[Gregb11]

In I6 of the Apparel Inventory tab, try this formula:

=COUNTIFS(Table15[W/O SHIRT SIZE],[@SIZE],Table15[W/O SHIRT H/O],"<>")

[GolfNut39]

That work absolutely perfect. Thank-you so much Greg.

[Gregb11]

You're welcome, and thanks for the feedback/rep.