Dragging Countif functions

Aussie Dave · May 24th, 2002, 12:27 AM

G'day
This may be a simple formatting question, but I've spent hours on it, to no avail! I have a list of 1000 random data, and am looking to generate a histogram. To acheive this I am trying to group the data into 20 or so groups, each forming a column in the graph. To figure out how many values go in each group, I am using the following:
=COUNTIF($A$2:$A$102,">100")
This works fine. However I want to replace the >100 term with >c3 (i.e. a cell reference rather than a number), so I can drag the formula to cover all 20 groups, rather than typing the 100, 200, 300 in each new row.

Thanks in advance!
Dave

Aladin Akyurek · May 24th, 2002, 12:49 AM

=COUNTIF($A$2:$A$102,">"&C3)

[ This Message was edited by: Aladin Akyurek on 2002-05-23 23:49 ]

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

May 24th, 2002, 12:27 AM	#1
Aussie Dave New Member Join Date: May 2002 Location: Australia Posts: 1	G'day This may be a simple formatting question, but I've spent hours on it, to no avail! I have a list of 1000 random data, and am looking to generate a histogram. To acheive this I am trying to group the data into 20 or so groups, each forming a column in the graph. To figure out how many values go in each group, I am using the following: =COUNTIF($A$2:$A$102,">100") This works fine. However I want to replace the >100 term with >c3 (i.e. a cell reference rather than a number), so I can drag the formula to cover all 20 groups, rather than typing the 100, 200, 300 in each new row. Thanks in advance! Dave

May 24th, 2002, 12:49 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=COUNTIF($A$2:$A$102,">"&C3) [ This Message was edited by: Aladin Akyurek on 2002-05-23 23:49 ]