COUNTIF problem
COUNTIF problem
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: COUNTIF problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm wanting to compare two columns of figures, and below the second one use some sort of Count function to establish how many times the values in the second column are smaller than, equal to, and greater than the corresponding ones in the first column. Any idea's what formula I use? I thought it was Countif but I can't get it to work.
    Thanks alot.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 03:41, RichieF wrote:
    I'm wanting to compare two columns of figures, and below the second one use some sort of Count function to establish how many times the values in the second column are smaller than, equal to, and greater than the corresponding ones in the first column. Any idea's what formula I use? I thought it was Countif but I can't get it to work.
    Thanks alot.
    =COUNTIF(Cell_1st_Column,">"&Cell_2nd_Column)
    "Have a good time......all the time"
    Ian Mac

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ian,

    Thanks for the reply, however while this works if I compare each row of the columns individually, it wont work if i try to use it on a range. (i.e. where you have put "cell value", i want to put a range instead). I know, i'm stupid !! Any ideas ??

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,771
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-18 03:41, RichieF wrote:
    I'm wanting to compare two columns of figures, and below the second one use some sort of Count function to establish how many times the values in the second column are smaller than, equal to, and greater than the corresponding ones in the first column. Any idea's what formula I use? I thought it was Countif but I can't get it to work.
    Thanks alot.
    =SUMPRODUCT((B1:B5 =SUMPRODUCT((B1:B5=A1:A5)+0)
    =SUMPRODUCT((B1:B5>A1:A5)+0)

    You can also look at DCOUNT.

    Aladin

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Aladin...just what I was looking for.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com