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" wrote in message
...
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:H10974%),--(H3:H109<85%))

--

HTH

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


"Tkshowers" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.