Thanks:  0
Likes:  0

# Thread: COUNTIF problem

1. 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. 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)

3. 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. 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. Thanks Aladin...just what I was looking for.

## User Tag List

#### Posting Permissions

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