Afternoon Excel Community (that title descriptive sounded confusing enough :D )
First top poster and hoping someone can help.
In this image, for each value in each of the 'Attack' column, the maximum value that manually gets put in is up to 5 however on occasions the value will be less. As per this example.
Player RD by RD stats.jpg
What I am trying to work out is, how do I calculate the formula for a running total to be put into a different worksheet, in the ' Total Missed Attacks' column. Keeping in mind though, as each round progresses the total value will always increase by +5
Total Page.jpg
As an example, lets say as round progresses and we are in the 3rd round. This means there has now been a 15 possible attacks but using the stats in image 1, the player only did 12 attacks. I'm trying to work out how in image 2 that I can have the total missed attacks displayed in 'Player League Total Stats' worksheet - Column F4.
The issue is, as another round is completed, there will be an additional 5 value to be added to the accruing 'Total Missed Attacks' column, which also needs to work out the difference that the player completed attacks for that round.
Does that make sense??
Bookmarks