|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content='"MSHTML 4.71.1712.3"' name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000>Thanks,</FONT></DIV>
<DIV><FONT color=#000000></FONT> </DIV>
<DIV>Sometimes some of this stuff is so simple I overlook the obvious.</DIV>
<DIV> </DIV>
<DIV>But what has me stumped now is how to count the <FONT
color=#000000>occurrences </FONT>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>If this could be done it would really cap off my study.</DIV>
<DIV> </DIV>
<DIV>Thanks again,</DIV>
<DIV> </DIV>
<DIV>Bill N.</DIV>
<DIV>Milwaukee, WI USA</DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Gitanshu Buch <<A
href="mailto:OnWingsOfEagles@xxxxxxxxxxxxx";>OnWingsOfEagles@xxxxxxxxxxxxx</A>><BR><B>To:
</B>metastock@xxxxxxxxxxxxx
<<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Date:
</B>Wednesday, October 06, 1999 07:45 PM<BR><B>Subject: </B>Re: Excel
question. Help for the simple minded.<BR><BR></DIV></FONT>
<DIV><FONT size=2>=if(A2>0,a2," ") for the copy of col a with
positive value and space blank if 0 or negative value.</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>Also is there any formula that in the end would count the number of
entries in Col B? </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=2>=count(b2:b200) should be placed in the cell where you
want the result.</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Oct 07 08:11:25 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id IAA10658
for <neal@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 08:07:09 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id WAA27301
for metastock-outgoing; Thu, 7 Oct 1999 22:30:07 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id WAA27293
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 7 Oct 1999 22:30:03 -0600
From: dllabarre@xxxxxxxxx
Received: from franklin.appliedtheory.com (franklin.appliedtheory.com [192.77.173.116])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id IAA17303
for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 08:14:54 -0600 (MDT)
Received: from mta.nyseg.com (mta.nyseg.com [199.98.200.7])
by franklin.appliedtheory.com (8.8.8/8.8.8) with SMTP id KAA14497
for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 10:00:44 -0400 (EDT)
Received: by mta.nyseg.com(Lotus SMTP MTA v4.6.3 (733.2 10-16-1998)) id 85256803.004D2DA6 ; Thu, 7 Oct 1999 10:02:59 -0400
X-Lotus-FromDomain: NYSEG@xxxxxxxx
To: metastock@xxxxxxxxxxxxx
Message-ID: <85256803.004D2D4D.00@xxxxxxxxxxxxx>
Date: Thu, 7 Oct 1999 09:55:21 -0400
Subject: Re: Excel question. Help for the simple minded.
Mime-Version: 1.0
Content-type: multipart/mixed;
Boundary="0__=JSLq8LBTLrKH5HiLbfmMxkQS0dqV5OkYbt7jcWNoaO4ijTOtgpYgfmC6"
Content-Disposition: inline
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Bill,
The way I've done this is to set up a query on a new sheet. The query has
parameters that allows you to include cells from the previos sheet for a
specific range (between 3 and 4). Then you just apply the counter to this
column of data.
Don L.
WebMaster/Software developer
http://www.stny.rr.com/abbracadabra/Cybercast
"Bill N." <frt1000@xxxxxxxxxx> on 10/07/99 06:52:58 AM
Please respond to metastock@xxxxxxxxxxxxx
To: metastock@xxxxxxxxxxxxx
cc: (bcc: Donald L. LaBarre)
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.
Attachment Converted: "c:\eudora\attach\att1.htm"
|