COUNTIF problem

RichieF · Apr 18th, 2002, 04:41 AM

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 · Apr 18th, 2002, 04:45 AM

Quote:

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 · Apr 18th, 2002, 05:03 AM

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 · Apr 18th, 2002, 06:32 AM

Quote:

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

RichieF · Apr 18th, 2002, 06:38 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 04:41 AM	#1
RichieF New Member Join Date: Apr 2002 Posts: 20	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.

Apr 18th, 2002, 05:03 AM	#3
RichieF New Member Join Date: Apr 2002 Posts: 20	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 ??

Apr 18th, 2002, 06:38 AM	#5
RichieF New Member Join Date: Apr 2002 Posts: 20	Thanks Aladin...just what I was looking for.