Results 1 to 3 of 3

Count numbers in a list which match a condition

Threaded View

AlexnL12 Count numbers in a list which... 12-18-2014, 03:03 PM
mcmahobt Re: Count numbers in a list... 12-18-2014, 03:05 PM
AlexnL12 Re: Count numbers in a list... 12-18-2014, 03:18 PM
  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Birmingham,England
    MS-Off Ver
    Excel 2013
    Posts
    42

    Smile Count numbers in a list which match a condition

    Hi

    Please can someone help me. I have a list of numbers and wish to simply count the number of numbers in the list which match a condition. In this case I wish to count the number of numbers which are greater than or equal to 20 and enter it in the cell below the list. I have attached the list.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If formula to match a list of numbers to another list
    By Robotacha2010 in forum Excel General
    Replies: 5
    Last Post: 01-19-2011, 11:26 AM
  2. count numbers that match
    By dealer in forum Excel General
    Replies: 7
    Last Post: 10-08-2010, 03:09 AM
  3. Count numbers in a list if a condition is true
    By sakau2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2010, 05:08 PM
  4. Count unique numbers with an AND condition????
    By ajajmannen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2007, 09:15 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