Basic Excel Question - Help Needed

I need to make a make a frequency distribution (make a table). I went to COUNTIF inputed the range of data say (A1:A20) but I'm have difficulty with putting in the criteria. I keep getting an error. There are four data values (1)(2)(3)(4). I'm new to excel and would appreciate any help. I'm trying to make a table and then make a bar/pie chart.

My version of excel is 2003. Not sure if that makes a difference.

sorry mate I think you are going down the wrong road...

I do it this way (see attached file)

in cells A1:a20 put your data
in cells c1:c9 put your bins (ie what you want to divide the data into - in my examples it is 5's)
i cell d1 use the function button to get "frequency" or type
=FREQUENCY(A1:A20,C1:C9)

then press ENTER

Then drag the formual down to cell d10 then (THIS IS IMPORTANT) press the f2 key then press (at the same time CTRL+SHIFT+ENTER)

This will make an array that contains all the values for each bin with d10 being values > than the last bin

I hope this helps

Mark

I'll try this. Thank you for the quick response.