Spreadsheet Formulas

[Nine Toes]

Can somebody give me some help on an MS Works spreadsheet?

I have an array of numbers, and I'm trying to figure out a formula that will count how many cells in a range of cells contain a specific number.

The functions included in MS Works are pretty limited, so I'm trying to combine them to get the desired effect I'm looking for.  Such as this:
=COUNT(=IF(A1:E5,1,0)=1)

But the formulas I've come up with either don't work the way I want them to, or aren't valid formulas (they contain errors, apparently).

Can anyone offer some help?

[sloppy]

The formula is =COUNTIF(A1:E5,X) X being the number in the cells you want to have counted.  If you want to count how many cells contain a certain word, you'd put that word in quotation marks.  =COUNTIF(A1:E5,"X")

[Nine Toes]

I believe I tried that once already.  It apparently only works with Excel.  I only have MS Works (yeah, stop laughing...).

But, I'll give it another try.  Thanks much.

[HeirOfNorton]

If that doesn't work (and you can't/won't shell out for MS Office) I recommend trying OpenOffice.org. It's is a very hefty download, but it's free, and, in my experience, usually works just as well as anything in Office.

HoN

[Afflict]

Open office is what I use its awesome, and well free works just as good as excell. Can even save into excel format..

[Nine Toes]

Sweet!  I'll jump right on it.

Thanks.