countif cell back to 0

[jarhead58]

How can I return my count to "0" after using this formula

=MOD(COUNTIFS(F13:T21,R2)+COUNTIFS(F13:T21,"Ground out")+COUNTIFS(F13:T21,"Fly out")+COUNTIFS(F13:T21,"Foul out")-1,3)+1

when F13:T21 are cleared? TIA

 

[jarhead58]

When you press the button you are copying cell AA2. This puts a 1 in the cell and a picture. The outs formula is looking for "PO" so it does not pickup the pick off since the cell has a 1 in it. Change AA2 to PO and it should work. Cell Z2 for TO has the same problem.

I'll give it a shot when I get back! Thanks

 

[jarhead58]

The one was actually the way I was keeping the hit number the same. Thats why I used a text box with PO. I have to figure out a way to keep the hit registered.

 

[Scott T]

Some score cards will have 1B 2B 3B HR BB at top of the cell to be circled to indicate how the runner got on base. Maybe you could use 5 check boxes to track the hit.

How paper score cards are done
https://youtu.be/XtmtVHXQpD0

 

[jarhead58]

Good afternoon Scott!

Something weird started happening when the 3rd out happens and it goes to the sub "currinning". I get a Run-time 13 error everytime the Call to currinning happens. No matter what type of out closes the inning. Here is a link to the file! https://www.dropbox.com/s/q6sz23twplrbcma/Cubs.xlsm?dl=0 TIA

 

[jarhead58]

Haven't seen you on for awhile so I will post in the general forum! Have a good day!

 

[jarhead58]

Never mind, figured it out!