Re: Excel question. Help for the simple minded.

["Walter Lake" <wlake@xxxxxxxxx>]

Here's a counting AutoFunction utility developed by Rob Bruce, that Excel
users can download and adapt to their own use.

http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm

Best regards

Walter

----- Original Message -----
From: Bill N.
To: metastock@xxxxxxxxxxxxx
Sent: Thursday, October 07, 1999 6:52 AM
Subject: Re: Excel question. Help for the simple minded.


Thanks,

Sometimes some of this stuff is so simple I overlook the obvious.

But what has me stumped now is how to count the occurrences of a certain
value in a column of figures.  Say col. B contained the following values:
3.7, 9.1, 4.8, 3.2, 0.6, 7.0, 2.1.  Now I would like to be able to count the
number of rows that have values greater than 3 but less than 4.  Obviously
the correct answer to the above would be "2" as we have 3.7 and 3.2 as
values.

I've tried using the "count", "countif", and even "dcount" functions but
keep getting errors.  And if I don't get an error the formula generates a
"true" or "false" statement.

If this could be done it would really cap off my study.

Thanks again,

Bill N.
Milwaukee, WI USA
-----Original Message-----
From: Gitanshu Buch <OnWingsOfEagles@xxxxxxxxxxxxx>
To: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Date: Wednesday, October 06, 1999 07:45 PM
Subject: Re: Excel question. Help for the simple minded.


=if(A2>0,a2," ") for the copy of col a with positive value and space blank
if 0 or negative value.
Also is there any formula that in the end would count the number of entries
in Col B?


=count(b2:b200) should be placed in the cell where you want the result.