I call the local high school games on the radio and want my stat guy to have an excel sheet where he can type on the D&D, the YL, Player # and gain/loss yardage. When he enters that information I want to have the D&D & YL calculated for the next play depending on the result of the play prior. Is there a formula for that? Also, what do the cells need to be formatted too?
Secondly, I want to have the drive populate on a drive result sheet, a individual game stat sheet and YTD stat sheet accumulative. I have all the sheets ready, however I do not know how to combine the information to populate all of them without having to enter the info 4x. Is there a formula for that?
For anyone who could help it would be greatly appreciated.
Secondly, I want to have the drive populate on a drive result sheet, a individual game stat sheet and YTD stat sheet accumulative. I have all the sheets ready, however I do not know how to combine the information to populate all of them without having to enter the info 4x. Is there a formula for that?
For anyone who could help it would be greatly appreciated.
