Wrist Band Series -Gate Tally

[cemxmark]

We use wristbands that have sequential numbers. Our current gate tally requires the first band start number (this band not sold) and the last band stop number (this band not sold).

I would like to insert beginning band number (e.g. 6000) then final band number (e.g. 6010) then show total bands sold (minus start and stop bands which are NOT sold). The total $ column simply multiples the total bands sold against cost of band.

Where no band numbers are entered, I want the total sold to indicate a 0 value, not -2 like my formula does.


Any help would be greatly appreciated.



Gate Tally.PNG

[ARGK]

Hi
You could use something like:
=IF(AND(B2="",C2=""),"0",(C2-B2-2))
Hope this helps
Tony

[shg]

=(count(b2:c2)=2) * (c2-b2+1)

[cemxmark]

shg,

thank you this worked

=(COUNT(B8:C8)=2) * (C8-B8-2)

[shg]

It may, but it doesn't agree with the numbers in your example.

[cemxmark]

thank you

I have attached the tally sheet - I don't entirely understand the formula - it does seem to work correctly.

Then intent is to put the actual start and stop band numbers into the tally sheet (these to bands are not sold). The formula
them accounts for bands sold minus two bands not sold - then the band cost is multiplied by that total.

My goal is to lock both forms, so the attendants only input information in highlighted boxes and then print and send in
pdf each day.

Thanks again for your help!

[shg]

If only the tickets between 6020 and 6050 were sold, excluding the endpoints, that is 6021 through 6049, which is 29 sold, no?

[cemxmark]

At face value - it looks like

6050-6020=30-2 (not sold)=28

But when counting actual tickets it's actually 29 tickets sold.

This may be simple, but I don't see it

[shg]

If the ticket numbers were 1 and 2, how many tickets were sold? Show your work.

[cemxmark]

If start ticket is 0001 and stop ticket is 0002 - I would have sold tickets

But if I subtract 0002-0001=1 ticket sold?

[cemxmark]

I really want to understand the logic, but more importantly need the tally sheet to balance.

[shg]

If you sold neither of the end tickets, then the number of tickets sold is =last-first-1

If the first ticket is 1 and the last is 2, then 2-1-1 = 0 tickets sold.

It's arithmetic -- I'm not sure how else to explain it.

[cemxmark]

It clicked - I just didn't see it - thank you very much for your help.

I will revise the formula to -1 , have a great week!

[shg]

You're welcome.