Re: Formula for a range of percentages
- From: Tkshowers <Tkshowers@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 12:24:04 -0700
First, thank you for the responses! I am supposed to be the most "Tech
literate" of the teachers and have been pulling my hair out trying to get
this ready for the adminstration. Second, I tried both of the formulas, and
the result both time came out as 3500%. What am I doing wrong?
"Biff" wrote:
> Hi!
>
> =COUNTIF(H3:H109,">.74")-COUNTIF(H3:H109,">.84")
>
> Biff
>
> "Tkshowers" <Tkshowers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@xxxxxxxxxxxxxxxx
> > Sorry, some of the posts mention this, but I do not know enough to figure
> > it
> > out. I am a teacher and I am trying to collect some data. Please help.
> >
> > I need a formula to count the number of grades that are greater than 74%
> > and
> > less than 85% in the cell range of H3:H109. Any help would be greatly
> > appreciated.
>
>
>
.
- Follow-Ups:
- Re: Formula for a range of percentages
- From: Bob Phillips
- Re: Formula for a range of percentages
- References:
- Formula for a range of percentages
- From: Tkshowers
- Re: Formula for a range of percentages
- From: Biff
- Formula for a range of percentages
- Prev by Date: In two workbooks, how do I create a formula that will look at a o.
- Next by Date: Re: Customize Mouse Pointer
- Previous by thread: Re: Formula for a range of percentages
- Next by thread: Re: Formula for a range of percentages
- Index(es):
Relevant Pages
|