I am trying to set up a layout of a toner tracking spreadsheet. As soon as I need to change a cart. I want to be able to say this:
cart #------Date---Page Count------Page Per Cart.
The way I was trying to set this up was that each time I change a cart the Page Per Cart column will change by subtracting cart 2 page per cart number from cart 1 page per cart number giving me a number of pages for each particular cartridge, then I eventually want to average them the Page Per Cart Column. I have tried to use repeating fields but that will only take the diference of the last repeated field with the new one. Any suggestions would be greatly appreciated. Thanks.
