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?
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")
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. :)
If that doesn't work (and you can't/won't shell out for MS Office) I recommend trying OpenOffice.org (http://www.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
Open office is what I use its awesome, and well free works just as good as excell. Can even save into excel format..
Sweet! I'll jump right on it.
Thanks.