+ Reply to Thread
Results 1 to 2 of 2

counting instances of decimals

  1. #1
    Registered User
    Join Date
    05-06-2004
    Posts
    4

    Question counting instances of decimals

    I'm trying to count how many times a number appears in a column. Easy enough. The catch is the numbers are 3 decimal places out and I want all the numbers starting with a certain tenth digit. So I want to know 4.001, 4.002, 4.003. I just need one count though, so I want to know how many 4.xxx's there are in a column.

    Please help!

  2. #2
    Registered User
    Join Date
    02-05-2005
    Posts
    57
    u need the DCOUNT function I think. for example, if these numbers are in the range A1 to A10, you'll need A1 to have a heading eg 'Numbers'. Then goto where there are some spare cells for example G1 and H1 type the same title (eg 'numbers') and in G2 type >3.9 and in H2 type <5. then your formula will be
    DCOUNT(A1:A10, A1, G1:H2)
    DCOUNT(DATABASE, TITLE, RANGE)

    it will then look in A1:A10 to see how many cells meet the criteris set in G1:H2, that is how many cells have a number greater than 3.9 but less than 5.

    hope this makes sense, although there may be an easier way?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1