COUNTIF problem

[RichieF]

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.

 

[Ian Mac]

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)

 

[RichieF]

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 ??

 

[Aladin Akyurek]

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<A1:A5)+0)
=SUMPRODUCT((B1:B5=A1:A5)+0)
=SUMPRODUCT((B1:B5>A1:A5)+0)

You can also look at DCOUNT.

Aladin

 

[RichieF]

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