+ Reply to Thread
Results 1 to 3 of 3

Count number occurences based on criteria Column

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    29

    Count number occurences based on criteria Column

    I get this work a lot and am looking for a much more effective way of working the dataset,

    I have numbers like 1.1, 1.2, 1.3 and so on.......
    These come under criteria like (1) = 1.1, 1.2, 1.3 and so on.....

    I am look for an automated way of doing a count of any number that falls under this criteria, so I want to count based on criteria (1) it would count all 1.1,1.2,1.3 and so on as one count.

    Hope this is clear, I am attaching a sample document to see how it is laid out and if you have any questions please ask

    Appreciate your help on this guys

    Code Counts.xlsx

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Count number occurences based on criteria Column

    Well I put a value in cell B1 and then used this formula:

    =SUMPRODUCT(--(LEFT(A1:A55,LEN(B1))=LEFT(B1,LEN(B1))))

    Will return the number of values in column A that start with the value in B1.

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Count number occurences based on criteria Column

    I don't really get this, it returns 0 if I use it in the worksheet labeled "put counts of criteria here".

    Care to shed some light on what you mean or use the excel sheet as an example?

+ 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