Conditional Counting

jamjar · Apr 28th, 2002, 06:29 AM

I have been trying to work this problem out all day, and I am sure it must be something simple that I am missing.

I want to count the number of times a cell's value is over an average. This works :

=Countif('Stock Data'!F5:F24;">0,96")

but if I change it to use the cell variable, eg:

=Countif('Stock Data'!F5:F24;">E17)

It doesn't. If any one can help I will be really grateful !

Paul B · Apr 28th, 2002, 06:53 AM

Try =COUNTIF('stock Data'!F5:F24,">"&E17)

jamjar · Apr 28th, 2002, 07:36 AM

Thanks Paul B, it worked !

Corni · May 19th, 2002, 08:37 PM

Sometimes the SUMIF form for COUNTIF works handy as an array formula. In your case:

{=SUM(IF('stock Data'!F5:F24>E17,1,0))}

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

Apr 28th, 2002, 06:29 AM	#1
jamjar New Member Join Date: Apr 2002 Location: Frankfurt Posts: 4	I have been trying to work this problem out all day, and I am sure it must be something simple that I am missing. I want to count the number of times a cell's value is over an average. This works : =Countif('Stock Data'!F5:F24;">0,96") but if I change it to use the cell variable, eg: =Countif('Stock Data'!F5:F24;">E17) It doesn't. If any one can help I will be really grateful !

Apr 28th, 2002, 06:53 AM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Try =COUNTIF('stock Data'!F5:F24,">"&E17)

Apr 28th, 2002, 07:36 AM	#3
jamjar New Member Join Date: Apr 2002 Location: Frankfurt Posts: 4	Thanks Paul B, it worked !

May 19th, 2002, 08:37 PM	#4
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Sometimes the SUMIF form for COUNTIF works handy as an array formula. In your case: {=SUM(IF('stock Data'!F5:F24>E17,1,0))}