I have made 24 sheets that track an increase in units developed from one month to the next and total on a summary sheet outlining the 24 months. At a point when any particular month reaches a total of 70 it needs to add 1 to another cell and that cell is then referenced to the summary sheet. This count continues to increase and over the 24 months can reach several multiples of 70. (140,210,280,350, etc)
For example month one may have 5, month two has 48 and month 3 has 73, at this point a 1 (rounded down) would show as because 73/70 =(1)
In month 4 it might be 210, I would want this to display (2) as 210/70 = 3 minus previous month 3 total of (1), and so on up to the 24 month point.
I trust I have given enough info or explained it properly. As I am sure you have guessed I am not very good with excel but know that basically is possible with it!
Thank you for your help!
Regards,
Warren
Bookmarks