Formula to calculate how many numbers falls between a specific sequence.

Greetings Everyone,

I have a ticket booklet which starts at ticket number 6551 to 6600. I need help in writing a formula that will calculate how many tickets are within this range.


Thanks.
HB

if value of A1 is 6600 & B1 is 6551
to find out tickets in between Your formula will be = (B1-A1)-1

if you don't have ALL of them (there are numbers missing) use:

Formula:

Please Login or Register  to view this content.