COUNTIFS function

[cmboruch]

For some reason, I just can't figure this out. I have a column with class grades and I need to count how many students fall between .63 and .77. I used a countifs formula, but it's not calculating it properly.

I am using the same range for both counts and I think it is counting some of the cells twice.

[TABLE="width: 387"]
<tbody>[TR]
[TD="align: right"]80%[/TD]
[TD][/TD]
[TD]>78%[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]90%[/TD]
[TD][/TD]
[TD]between .63 and .77[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]93%[/TD]
[TD][/TD]
[TD]between .48 and .62[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]33%[/TD]
[TD][/TD]
[TD]<.61[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]83%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]83%[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]100%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]57%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FinancialAnalystKid]

If "B1:B100" contains your grade range comments.

=countif(B1:B100,"between .63 and .77")

If it's the 'range' of grades you're counting and not your comments and it's in "A1:A100"

=countif(A1:a100,"<=.77")-countif(a1:a100,"<=.63")

 

[JackDanIce]

Try:

=COUNTIF(A:A,"<0.77")-COUNTIF(A:A"<=0.63")

 

[cmboruch]

I tried that and it comes up zero!

 

[FinancialAnalystKid]

Are you counting GRADES or counting COMMENTS of the Grades?

If your grades are more than 2 decimals like 77.1% or .771 then it won't count them.

 

[Weazel]

what count are you expecting to return?

=COUNTIFS($A$2:$A$10,">=.63",$A$2:$A$10,"<=0.71")

looking at your dataset zero would be correct

 

[cmboruch]

That worked. Thanks