Countif with 2 criteria

Closed
snoopy - Sep 13, 2008 at 05:53 AM
Xmaniac Posts 32 Registration date Tuesday September 9, 2008 Status Member Last seen September 17, 2008 - Sep 13, 2008 at 06:12 AM
Hello, I am a teacher.If i want to calculate the number of students with who has marks between ,let's say 0 to 29, what excel formula do I use.
Related:

1 response

Xmaniac Posts 32 Registration date Tuesday September 9, 2008 Status Member Last seen September 17, 2008 3
Sep 13, 2008 at 06:12 AM
Hi..

The formula is...

=COUNTIF(B1:B17,">=29")

B1:B17 is the points. (example)

">=29" is the criteria. (lower and equal than 29)
1