Countif with 2 criteria

Closed
Report
-
Posts
32
Registration date
Tuesday September 9, 2008
Status
Member
Last seen
September 17, 2008
-
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.

1 reply

Posts
32
Registration date
Tuesday September 9, 2008
Status
Member
Last seen
September 17, 2008
3
Hi..

The formula is...

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

B1:B17 is the points. (example)

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