Results 1 to 2 of 2

Thread: Countif problem

  1. #1
    Join Date
    Oct 2003
    Posts
    61

    Post Unanswered: Countif problem

    I have a spreadsheet in which i have some numbers in a column for example like this

    3
    4
    6
    8
    10

    Now i want to do a countif on this and only want to count whenever the number is between five and nine (so the answer should be two)

    How do i do this within the countif formula. What i do not want is to add an extra column with for instance an IF or an AND formula and do the countif on that extra column. I want to have this solved within the COUNTIF criteria
    Nobody dies a virgin because life screws us all!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Use this formula (adjust range to suit)

    =SUM(($A$1:$A$10<9)*($A$1:$A$10>5))

    But be sure to confirm with CTRL + SHIFT + ENTER (CSE, also called array-entered), rather than ENTER.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •