COUNTIFS function

I am doing a spreadsheet project for school and I cannot get the following to work: I am counting columns of numbers that represent grades for four different classes. I need to use the COUNTIFS function to count the number of students from another worksheet (data) that will get an A, B, C, etc. based on their number grade, i.e. <90 = A. So for that formula I am using:

=COUNTIF(data!B2:E119,">90") and getting the correct response (I think.)

This is the formula I am using for the grade ranges:

=COUNTIFS(data!B3:E119,"<80",data!B3:E119,">=70")

I should end up with 626 total students, but the counts add up to 521 instead. What am I missing?

Hello and Welcome to the Board,

On the surface nothing looks wrong with your formula.

Do you have a sample set of data without any personal data you can attach?

Do you have any text in the range you are trying to count?

Originally Posted by jeffreybrown

Hello and Welcome to the Board,

On the surface nothing looks wrong with your formula.

Do you have a sample set of data without any personal data you can attach?

Sorry. I took a break. OK. It is called teaching.xslx

Originally Posted by MarvinP

Do you have any text in the range you are trying to count?

No. It is all numbers between 0 and 110.

From your data you need to go down to E239 to pick up all the scores.

I think that is the problem.

Originally Posted by MarvinP

From your data you need to go down to E239 to pick up all the scores.

I think that is the problem.

Wow! Thanks! You are probably right, but why? Doesn't the data end in E119?

Originally Posted by DonkeyOte

It does in Column E but you have more student results in the other columns (see C239) - you must include these other rows in your range hence B3:E239

Thank you so much. My count is much closer, but it is still off by 8. Is my formula missing the zeros? I think there are eight of them. Do I need to add a third criteria to my COUNTIF formula?

Originally Posted by RM Rilke

Thank you so much. My count is much closer, but it is still off by 8. Is my formula missing the zeros? I think there are eight of them. Do I need to add a third criteria to my COUNTIF formula?

If you can provide what formula you are using I would be glad to help.

Are you still looking at the same range and what should your result be?

Originally Posted by jeffreybrown

If you can provide what formula you are using I would be glad to help.

Are you still looking at the same range and what should your result be?

I'm still looking at the same range. The workbook is attached. On the Counts sheet you can see the formulas for each grade, i.e. 90 and above is an "A" 80-89 is a "B", etc.

This is the COUNTIFS formula to find all of the students who will get a "B":

=COUNTIFS(Data!B3:E239,"<90",Data!B3:E239,">=80")

Never mind. My count was off by eight, not the formulas! Thanks anyway for offering to help!!!