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

cedmonds

New member
Joined
Jun 17, 2011
Messages
4
Reaction score
0
Points
0
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

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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

New member
Joined
Jun 17, 2011
Messages
4
Reaction score
0
Points
0
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.
 
Top