Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
=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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |