LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting cells that "contain" a text string Dave Excel Discussion (Misc queries) 2 September 5th 07 05:16 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Formating numbers &"Text" to appear as currency &"Text" in formula Robin K. Excel Discussion (Misc queries) 6 May 7th 07 02:03 PM
Related to "Counting cells..." (post below) jimbob Excel Discussion (Misc queries) 1 July 4th 06 08:23 PM
In excel counting cells in a range which meet condition "Xand<X" Uncivil Servant Excel Worksheet Functions 1 May 19th 06 02:37 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"