Results 1 to 14 of 14

Counting cells - changing criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    7

    Counting cells - changing criteria

    Happy new year everyone

    I am trying to figure out how to formulate a countif or similar function that would count the number of cells which would work with changing criteria and accomplish the following scenario.

    As you see in the attached image the left column contains the variables and the right column contains the instances each variable occurs individually.

    The range is always constant
    Though the criteria is ever changing the variables are always numeric and descending (although the example shows the variables ascending)

    Any feedback would be much appreciated.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-13-2014, 07:08 PM
  2. Replies: 3
    Last Post: 03-01-2012, 06:17 AM
  3. Replies: 5
    Last Post: 12-31-2011, 06:10 AM
  4. [SOLVED] Counting Cells with multiple criteria.One criteria supporting wild
    By Azhar Saleem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2005, 07:06 AM
  5. [SOLVED] Counting Cells with multiple criteria.One criteria supporting wild
    By Azhar Arain in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2005, 05:06 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