Help with getting an answer on finding the count of range.

[cedmonds]

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?

 

[Ken Puls]

Hi there, and welcome to the forum!

Try this (row 2)

=IF(AND(A2>0,B2>0),A2-B2+1,0)

Copy that down column C and you should only have numbers in rows that actually have page number data. You can then total it using a SUM formula and you should be good to go.

 

[cedmonds]

Thank you!

Thank you!
Thank you!
Thank you!

I knew there had to be a quick way to do but I could not remember or think of it. I really appreciate the help.

 

[Ken Puls]

Not a problem, glad it worked for you.