Previous Topic Next Topic

Countif formula

Closed
onkar - Jul 20, 2009 at 04:08 AM
 Trowa - Jul 20, 2009 at 08:18 AM
Hello,
i would like to know the numbers from given all three condition at a time. My condition are as foollows-
1) How many students got marks between 60%-79% from the given range.
2) How many sc caste students got marks between 60%-79% from the given range.
3)How many boys got marks between 60%-79% from the given range.
Please take all condition in account and give the numbers.
60 sc boys
68 boys
75 open girls
86 sc boys
74 sc girls
65 open boys
70 sc girls
64 sc boys
76 open girls
72 open boys

1 response

Answer 1 / 1
Trowa
Jul 20, 2009 at 08:18 AM
Hi Onkar,

I don't fully understand you.

You've got 3 conditions: students, sc caste student and boys.
And 5 results: sc boys, boys, open girls, sc girls, open boys.

??????
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Use of '@' in formulae
Quarterp -
Quarterp -

6 responses