Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
I am trying to create a formula that will count a set of given numbers. I
want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function it equals 89! I am one off! Any help would be appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
You will always be one off because subtraction does not count the lowest
number. Write a formula like this, assuming that 73267 is in cell B2 and 73356 in B3: =(B3-B2)+1 "Willyum" wrote in message ... I am trying to create a formula that will "count" a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function - it equals 89! I am one off! Any help would be appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
Just add one to your formula.
Imagine you have three tickets, numbered 11 to 13 - if you take the smallest number away from the largest number you will have 2, so clearly this is one less than the number of tickets. Hope this helps. Pete On Jan 11, 3:59 pm, Willyum wrote: I am trying to create a formula that will "count" a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function - it equals 89! I am one off! Any help would be appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
=A2-A1+1
"Willyum" wrote: I am trying to create a formula that will count a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function it equals 89! I am one off! Any help would be appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
Unless it is important later to know who sold a particular ticket, just forget the numbers and just enter the persons name and how many tickets you gave them......otherwise, it would take a more sophisticated formula to insure the correct answer for the oddball conditions of a zero in either or both columns. Vaya con Dios Chuck, CABGx3 "Willyum" wrote: I am trying to create a formula that will count a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function it equals 89! I am one off! Any help would be appreciated! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for "counting" numbers - bot cells!
Unfortunately, it is complicated. The collective They want to be able to
track the tickets, who sold what tickets, what tickets were not sold, percentage of tickets sold by a Rep that won and lost. I could go on and on. FUN, I know.. "CLR" wrote: Unless it is important later to know who sold a particular ticket, just forget the numbers and just enter the persons name and how many tickets you gave them......otherwise, it would take a more sophisticated formula to insure the correct answer for the oddball conditions of a zero in either or both columns. Vaya con Dios Chuck, CABGx3 "Willyum" wrote: I am trying to create a formula that will count a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how many are given to each representative of my group. The issue is the numbers printed on the tickets are large and each member receives various amounts of tickets. Here is an example I give Rep A ticket numbers 73267 through 73356, which are 90 tickets. If I use the subtract function it equals 89! I am one off! Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells that "contain" a text string | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Related to "Counting cells..." (post below) | Excel Discussion (Misc queries) | |||
In excel counting cells in a range which meet condition "Xand<X" | Excel Worksheet Functions |