Ask Your Question
0

How can I count number of students whose marks lies between 40 to 50 (say) in a column? [closed]

asked 2013-02-04 12:41:31 +0100

rajalaria gravatar image

How can I count number of students whose marks lies between 40 to 50 (say) in a column?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 04:46:12.024620

2 Answers

Sort by » oldest newest most voted
0

answered 2013-02-04 14:34:00 +0100

mikebibo gravatar image

The usual COUNTIF function doesn't work with multiple criteria. Perhaps something like:

=SUMPRODUCT((A1:A10>40)*(A1:A10<50))

edit flag offensive delete link more

Comments

Given a random assortment of numbers in A1:A10, this formula seems to give the right count of the numbers falling between 40 and 50 (exclusive).

qubit gravatar imagequbit ( 2013-02-27 06:11:03 +0100 )edit
1

answered 2013-02-04 15:00:34 +0100

Pedro gravatar image

Or you can simply use COUNTIF as in
COUNTIF(A1:10;">=40")-COUNTIF((A1:10;">50")

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-02-04 12:41:31 +0100

Seen: 115 times

Last updated: Feb 04 '13