Currently the following works for 3 columns in one table. I've been trying to optimize this so it is not so repetitive but keep running into errors. I also want to apply this to multiple tables named Game1:Game8.
=IFERROR(SUM(COUNTIFS(Game1[Bat Order:],[Name],Game1[1st Inn.],"P"),COUNTIFS(Game1[Bat Order:],[Name],Game1[2nd Inn.],"P"),COUNTIFS(Game1[Bat Order:],[Name],Game1[3rd Inn.],"P")),"")
Any suggestions would be most appreciated.
Hello scottmail,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Note I am trying to due this calculation on the Roster worksheet. Essentially I would like to calculate how many times each player may be playing a particular position in the field (since it will change each inning and each game). I want to make sure the rotation is balanced. Thanks again for anyone's help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks