Hi, I’m working on tracking what has been paid in fees by team/player based on week. Does anyone know what formula would work to have the spreadsheet only total the over/short amount based on weeks actually bowled? What’s happening is I’m having subs bowl, their over/short amount is way off because they’re being totaled by all weeks instead of weeks actually bowled. I’m not sure how to change my over/short formula to only reflect based on weeks bowled. Do I need to add a column(s) where I mark whether or not a player bowled or somehow tell excel that if no number is entered they didn’t bowl, and if 0 is there they bowled but didn’t pay?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Bowling League Fee Tracking
- Thread starter MKLXL32
- Start date
