+ Reply to Thread
Results 1 to 3 of 3

Counting number of cells with a value

  1. #1
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    286

    Counting number of cells with a value

    A have a colum with (a lot of) numbers.
    I want to count the number of cells that have a value between 250 and 500.
    I presume I shall use the COUNTIF-function, but I am stuck....
    Can anybody help ?

    Saturn
    Last edited by Saturn; 10-04-2011 at 11:28 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Counting number of cells with a value

    Try COUNTIFS (with an "S") , e.g. for column A

    =COUNTIFS(A:A,">=250",A:A,"<=500")

    that includes both 250 and 500 and everything in between....
    Audere est facere

  3. #3
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    286

    Re: Counting number of cells with a value

    Great, daddylonglegs!!

+ 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