I have the following information:
Start number page in stack (Col. B)
End Number page in stack (Col. A)
I need to know the exact number of pages (Col. C)
Col.A Col. B Col.C
Column C also needs to total at the bottom of my sheet and the I need to have the formula populated in the sheet. This is keeping me from doing something as simple as A-B+1. Because if i do it will populate 1 in all of the yet unused Column C cells thus screwing my subtotal up. how can I get around this or is there a formula that would give me a real total with out adding the 1?
Start number page in stack (Col. B)
End Number page in stack (Col. A)
I need to know the exact number of pages (Col. C)
Col.A Col. B Col.C
Column C also needs to total at the bottom of my sheet and the I need to have the formula populated in the sheet. This is keeping me from doing something as simple as A-B+1. Because if i do it will populate 1 in all of the yet unused Column C cells thus screwing my subtotal up. how can I get around this or is there a formula that would give me a real total with out adding the 1?