Multiple criteria in COUNTIF in Excel

  • Thread starter Thread starter ady_mech
  • Start date Start date
A

ady_mech

I am looking for help on COUNTIF function. I know of:

COUNTIF(range,criteria)

Above compares the data with only one criteria. What should I do if
want to include more than one criteria? For example, I have a list o
student marks in a Physics course (below is just an example):

56
66
77
78
67
79
86
70
69
88
90

I want to determine what number of students have marks in the range
51-60, 61-70, 71-80, 81-90 and 91-100. I guess, in order to do this, w
need to compare every cell with 2 criteria. For example, to count numbe
of students in range 51-60, we will need 2 criteria: >=51 and <=60. Ho
do I include these 2 criteria? Or is there a better way of doing i
than COUNTIF?

I will appreciate if someone could help me on this. I need thi
urgently
 
If your data is in A1:A11, try something like:

=SUM(($A$1:$A$11>=51)*($A$1:$A$11<=60))

NB: must be *array* entered (ctrl-shift-enter)

HTH,
Ryan
 
One way:

If your values are in in column A, put the top value in each of your
brackets in column B:

B1: 60
B2: 70
....
B5: 100

Select C1:C5 and array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=FREQUENCY(A1:A11,B1:B5)
 
Back
Top