Reply to thread

Message: [QUOTE="Willyum, post: 3743250"] 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! 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â€¦.. Any help would be appreciated! [/QUOTE]