Re: Formula for a range of percentages

Tech-Archive recommends: Fix windows errors by optimizing your registry



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.
>
>
>
.



Relevant Pages

  • Re: OT -- Because...
    ... literate. ... They don't even speak clearly or use decent English (which is still what they are supposed to be teaching). ... graduating teachers represented a broad spectrum of SAT scores. ...
    (rec.music.makers.guitar.acoustic)
  • Re: OT -- Because...
    ... a lot of the teachers are not what I would call ... literate. ... They don't even speak clearly or use decent English (which is ...
    (rec.music.makers.guitar.acoustic)
  • Re: How the Yankees should handle the Torre situation
    ... What's sad is that today, even teachers are barely ... :>>literate and no one cares. ...
    (alt.sports.baseball.ny-yankees)
  • Re: How the Yankees should handle the Torre situation
    ... What's sad is that today, even teachers are barely ... :>>literate and no one cares. ...
    (alt.sports.baseball.ny-yankees)