Re: Formula for a range of percentages

That did it! Thank you so much for all of your help. I knew there was a way
to do it, I just couldn't figure out how to make it happen.


"Bob Phillips" wrote:

> Format the cell as General, and you will get 35!
>
> BTW, if you use this formula it should be
>
> =COUNTIF(H3:H109,">.74")-COUNTIF(H3:H109,">=.85")
>
> assuming that there can be fractional scores, not just integer
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Tkshowers" <Tkshowers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2A3F2A96-1C3A-4FAE-8465-97F6AD5F2336@xxxxxxxxxxxxxxxx
> > 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: very hard deleting rows issue
    ... Your sentiments are well meant: ... >>> HTH ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Range names -VBA
    ... What is wrong with the responses given yesterday? ... HTH ... (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: sum if dates conditional
    ... we do it all the time in responses here. ... HTH ... (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: remove vba and functions when saving worksheet
    ... >> HTH ... >> Bob Phillips ... >> (remove nothere from email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: summing comma separated values in a range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ... >> number of csv to the number in the formula. ...
    (microsoft.public.excel.programming)