+ Reply to Thread
Results 1 to 3 of 3

Count occurrences of a value

  1. #1
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    148

    Count occurrences of a value

    On the attached worksheet i have data in cols A&E arranged by date and time & related data in col AK.
    From col AK i wish to count the number of digits less than 3 in each block,the results being given in col BA.
    Is it possible (without using a pivot table) to construct a formula not restricted in the number of rows to achieve this.Some cells in AK are blank,I have inserted empty rows between the blocks for clarity,there are no empty rows in the data.
    Many thanks for help given.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Count occurrences of a value

    You could try =COUNTIFS(E:E,405,AK:AK,">0")
    Just change the 405 for required number.

    Windy

  3. #3
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    148

    Re: Count occurrences of a value

    Thanks for the reply windy58.
    Correction .My original post should read number of digits less than 4 for each block in col AK.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count # of occurrences in range
    By HalPlz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2015, 02:28 AM
  2. count occurrences and total
    By vertprec in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 07:47 PM
  3. [SOLVED] Need a COUNT on occurrences per day
    By graymatterz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-22-2014, 11:51 AM
  4. [SOLVED] Count number of occurrences but if there are consecutive matches count them as one
    By michaljireht in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-26-2013, 08:26 PM
  5. count Re-occurrences
    By stevekirk in forum Excel General
    Replies: 15
    Last Post: 10-16-2006, 02:46 AM

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