PDA

View Full Version : Help with getting an answer on finding the count of range.



cedmonds
2011-06-17, 07:14 PM
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
2011-06-17, 07:46 PM
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
2011-06-17, 07:53 PM
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
2011-06-17, 07:56 PM
Not a problem, glad it worked for you. :)