Countif

CHam · Apr 18th, 2002, 02:27 PM

I am trying write a spreadsheet that will compare water quality data to a water quality standard and tell me how many times the data exceeded the standard. For example, I have data in the range a3:a63. I have a water quality standard in cell a65. I need to count how many of the values in the range a3:a63 exceeded the value in a65. I have tried using Countif but it won't allow me to use a cell reference as a criteria for comparison. Any suggestions?

Aladin Akyurek · Apr 18th, 2002, 02:35 PM

Quote:

On 2002-04-18 13:27, CHam wrote:
I am trying write a spreadsheet that will compare water quality data to a water quality standard and tell me how many times the data exceeded the standard. For example, I have data in the range a3:a63. I have a water quality standard in cell a65. I need to count how many of the values in the range a3:a63 exceeded the value in a65. I have tried using Countif but it won't allow me to use a cell reference as a criteria for comparison. Any suggestions?

=COUNTIF(A3:A63,">"&A65)

CHam · Apr 19th, 2002, 06:57 AM

It worked great. I bet I have wasted 8 hours over the past month trying to get this to work. Thanks!

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

Apr 18th, 2002, 02:27 PM	#1
CHam New Member Join Date: Apr 2002 Posts: 2	I am trying write a spreadsheet that will compare water quality data to a water quality standard and tell me how many times the data exceeded the standard. For example, I have data in the range a3:a63. I have a water quality standard in cell a65. I need to count how many of the values in the range a3:a63 exceeded the value in a65. I have tried using Countif but it won't allow me to use a cell reference as a criteria for comparison. Any suggestions?

Apr 19th, 2002, 06:57 AM	#3
CHam New Member Join Date: Apr 2002 Posts: 2	It worked great. I bet I have wasted 8 hours over the past month trying to get this to work. Thanks!