| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND DIFFERENCE BETWEEN 50 AND <60
hi...
Sir, For Eg: i have 1000 students...i entered marks to all the students now i need to fine the total students who have score 50 and <60 in each subject.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
One way ..
Assume the marks are listed within B2:B100 Enter in C1: 50, in D1: 60 Then put in E1: =SUMPRODUCT(($B$2:$B$100C1)*($B$2:$B$100<D1)) E1 will return the required count of students with marks 50 & < 60 Adapt to suit .. We could also copy E1 down to return other corresponding counts for other ranges of marks by inputting the required mark limits in C2:D2, C3:D3, etc -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Sarath.Ch" wrote in message ... hi... Sir, For Eg: i have 1000 students...i entered marks to all the students now i need to fine the total students who have score 50 and <60 in each subject.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
Hi, You could also try, =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"59") HTH -- Krishnakumar ------------------------------------------------------------------------ Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138 View this thread: http://www.excelforum.com/showthread...hreadid=496327 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
=COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"59")
Perhaps a slight revision: =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"=60") -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
=COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"59")
Perhaps a slight revision: =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"=60") Why? Biff "Max" wrote in message ... =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"59") Perhaps a slight revision: =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"=60") -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
=COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"59")
Perhaps a slight revision: =COUNTIF(B2:B100,"50")-COUNTIF(B2:B100,"=60") Why? A "tighter" upper limit, to conform more closely to the OP's "<60" ? Fractional marks may always be a possibility, e.g.: students with marks of say, 59.5 would have been excluded from the count if "59" was used. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FIND DIFFERENCE BETWEEN 50 AND <60
If scores are in Column B, =SUMPRODUCT(--(B1:B100050),--(B1:B1000<60)) -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=496327 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
