Formula for a range of percentages

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.

I'm sure there's another way, but try this:

=COUNT(H3:H109)-COUNTIF(H3:H109,"<=.74")-COUNTIF(H3:H109,">=.85")

"Tkshowers" wrote:

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

Hi!

=COUNTIF(H3:H109,">.74")-COUNTIF(H3:H109,">.84")

Biff

"Tkshowers" <Tkshowers@discussions.microsoft.com> wrote in message
news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@microsoft.com...
> 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.

=SUMPRODUCT(--(H3:H109>74%),--(H3:H109<85%))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tkshowers" <Tkshowers@discussions.microsoft.com> wrote in message
news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@microsoft.com...
> 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.

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@discussions.microsoft.com> wrote in message
> news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@microsoft.com...
> > 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.
>
>
>

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@discussions.microsoft.com> wrote in message
news:2A3F2A96-1C3A-4FAE-8465-97F6AD5F2336@microsoft.com...
> 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@discussions.microsoft.com> wrote in message
> > news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@microsoft.com...
> > > 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.
> >
> >
> >

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@discussions.microsoft.com> wrote in message
> news:2A3F2A96-1C3A-4FAE-8465-97F6AD5F2336@microsoft.com...
> > 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@discussions.microsoft.com> wrote in message
> > > news:8C397FF1-DEAC-47D6-9F06-68CFA0F033A3@microsoft.com...
> > > > 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.
> > >
> > >
> > >
>
>
>