MS Excel - Student Mark Sheet Calculation Sum, Average, Rank, Grade, Pass Fail, Status

[@shukussaim3472]

I was seeking for the fail and pass in one subject problem from within the month. But now i knew it. Thank you very much for this video. Lots of love.

[@evelinalumato9052]

Where did he get 35 in pass or fail

[@sajidapatel6082]

It was eassy explanation one query if I want to count how many students are fail in each subject than filter to be used count method

[@tewodroswerku3657]

It is a very good way of teaching and I understand each and everything thank you so much

[@manojsoni1475]

A failed student is getting higher rank than who passed also status of failed students is good Still required improvement in formula application

[@Samuelhauhulh3217]

I have a question?.... Suppose a student who failed in one subject but score more in total mark then a student who score less in total mark but pass in all the subject... So, the question is how to make a rank on this kind of situation?

[@esmeraldaunged3039]

millions of thanks to you sir for this video.. May God bless you more with knowledge to share..

[@samardeepsingh82]

Thanks for the video, at 9:01, you mentioned poor, shouldn't you have used if statement for less than 50 too? Just asking for clarification. 🙏

[@BegurKailash]

FOR FAILED CANDIDATES WHY RANK? His total score may be more and in subject he has failed, then he should be eliminated from ranking list.

[@manikantaveera1198]

How to pass fail cell

[@manikantaveera1198]

I have only true or false bro

[@mr.cracker9317]

Yes I check complete KZbin videos but no one KZbinrs make that video why failer students get rank, 😂, sometimes human brain stops working... Please help me to find rank of only pass students

[@AABHISIRFGAMING_YT]

​@@mr.cracker9317 you have to do conditional formatting

[@tapanjyotidevnath7241]

That is what I am searching but nobody is making a video on that topic.

[@smshah9400]

Excellent video😀😊😀😀😀😃😋

[@madalaramesh3536]

tq sir I'm using this process superb clarity

[@techhack2006]

mai kisi ki bhi video pr comment bahut bahut hi rare hi chance h ki kru but sir You are brilliant Thank you so much Your Teaching Skill is osm🔥🔥I Salute you sir🔥

[@storeone363]

you are great sir . it was really very helpful video specially for me

[@S.Wilondja]

I really love the way that you explain.

[@HariniGurudev]

Thank you brother....🎉🎉🎉 Now I can understand very well

[@elvranjes5824]

More grace ur the best teacher 🙏🏻🙏🏻❤️

[@maitriroy5626]

reallly goood teachinggg 💖💖💖💖💖💖💖💖

[@smshah6783]

The video is very excellent. I like to much

[@kaeez]

How quickly Mr. Ram went from being class topper to fail 😅

[@techtricksgh]

It very educative, thanks for sharing

[@vesetoluvese6518]

How easily you explained thank you sir

[@changadawa9482]

nice sir now my ict work is done

[@vinothkumar10]

thank u sir i have one doubt in case one student all subject have 35 marks 6*35=210 total another student one subject fail but this students 6-subject total 275 so how to calculate RANK ?? sir pls help me

[@fatiharslanoglu6482]

Thank you very much! My project worked.. Wonderful video!

[@bipinemansing]

Thank you so much sir 🙏🙏🙏🙏🤩🤩🤩🤩.

[@TreasureYakub-yj9xu]

It was really helpful

[@azbz7]

the best teacher I ever found .you mastered it!!

[@Burka_Tech6330]

amazing tutor. Thank you very much.

[@poornimarao6288]

If i want to find how many have passed or failed in a vertical way, how to find out

[@ayyappareddymandala5216]

Why did you allocate rank for failures? Can you calculate ranks in serial order for passed out students without allocating rank for failures?

[@hariprasad361]

excellent explanation thank you for your valuable time for us....!

[@mishal0303]

HOW TO FORMULATE FOR DIFFERENT TOTAL MARKS IN ON E EXCEL PRIMARY CLASSES TOTAL MAKS IS 400 AND SECONDARY CLASSES TOTAL MARKS 600 ALL CALCULATION IN ONE EXCEL RSULT RANK GRADE ETC IN OFFICE 2010

[@bhushankahar1361]

dear sir your video so excelent I was searching this kind of video . now I want how to print as a mark sheet kindly inform me . I am a teacher conducting exam, deportment , so i want to do all data works easily.

[@geethav7474]

Really super sir very useful to us

[@b2empiretv217]

You are the best,so simple and well detailed❤❤❤

[@akshaydarbar10]

Sir ,i hav a markshhet in this i want that students absent in all subject ..results colums shows absent instead of fail . How to write formula fr this Becasue in result colum i hav given a condition that if a students pass in all subjects ,shows pass ,or fail then how to add absent condition for this .

[@akshitachauhan6999]

Plz kya aap hme ye bhi bta sakte hai ki iski percentage aur division kaise nikalte hai

[@a.peterrobinson7297]

thank you very much sir, it is more useful for me. I am thankful to you sir.

[@moumitagupta8124]

Sir,the total range will be given in the question or we need to assume it as i2 and i11

[@coolbabysv]

Thanks for the video. If some student is failed, he should not be given ranking, also factor for absence. Then we have to calculate ranking. Is it possible

[@AMITJAIN-vo7tm]

How to use if function when any student is absent in all exam or particular subject.

[@alieaiahjawara7136]

Thanks, it's really helpful

[@DJ_FREESTYLE]

Very very helpful 👍☺️

[@Alkhalil180]

This Rand formula did not work if there comes duplicate value. for example if two student gets the same number

[@srinivasatk3907]

Hi Sir, If a student failed also you have given the status as good you have to include this condition as well both should be satisfied.

[@kevinogutu6553]

I wanted a case where there are values and grades how do you calculate total points

[@miriraipetermatete7462]

This is just awesome. I was having problems with my ICT tasks

[@neelamdh2926]

Wonderful.. 🙏 Thank You

[@virendersingh1234]

If the logical test for all the subjects are same. ..can we give them a single formula showing that if sub 1 to sub 6 less then 35 is fail

[@ShubhamSharma-ss9xk]

If i want the name of student which is having rank 1 in a different cell, how can i get that??

[@epicurean9866]

What if two columns will be interpreted. please help me Ex. c2 is frustration and e1 is instructional- the interpretation is frustration if c3 is instructional and e3 is independent- the interpretation is instructional if c4 is independent and e4 is independent- the interpretation is independent I have two cells to be interpreted please help me out to generate automatically

[@sairabanu2984]

Sir,while putting rank,we are getting rank for absentees also How to rectify this

[@sharmakhushi6594]

Sir hume agar sirf itna nikalna ho ki calculate the number of students failing in each subjects. Then konsa function use karenge?

[@v2sirchemistry645]

Sir jo students fail he uska percentage nahi chahiye marksheet me to uske liye kya formula banegi

[@rajeshakkineni4565]

i think we should given false value is null or empty then its not came

[@deepaharishchandraprabhu3166]

thank you sir, well explanation

[@macdonaldmendorinusnarib7892]

hi can you calculate how many students passed using sumif function, thank yu

[@prakashchandrabarik4651]

Sir Thanks 😊😊 Thanks Thankyou soooooooooo oo much My daout is clear 🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

[@smilemittal5164]

Sir please tell me that how to sort the list of students based on the final average marks?

[@paulataufa8160]

Hi, thank you for your excellent video demo, however i wanted to know how can you calculate the to 5 marks only and displayed on your total column?

[@AnilYadav-tt5ox]

W 4th

[@muhammadusamboaliyu5815]

Thanks very much. please how can I know my total marks range if I'm using different value

[@zer022pg]

Thank-you the video is very helful

[@anupomkumar2123]

Suppose 3 students get the same number in total, to make the position with the help of prior class Roll,Then what is conditions to make this result Sheet?

[@Areejxblr]

My exam is literally in 1h , tysmmmmmmm

[@shahataj1998]

Very informative thank you for teaching us

[@ashivashishth9759]

Thanks it's really very helpful I love this video

[@iddiali4102]

can i ge step by step method for creating a report system

[@dharmeshbaba9124]

Thank you sir you the best teacher

[@childrenreadingskills6024]

How do I send the answers and scored points (not points allocated to the questions) of my students' marked exam papers? They did not type the email address on the exam Google form.

[@yelatong8911]

Thank you so much sir it is so helpful

[@sandileshezi1436]

Last words knocked me out "So this is how simple it is, thank you" 🤣

[@baaboss5036]

You are the best teacher i forgot the IF function but you remembered me thanks

[@level2456]

Thanks for the video. How do we compile a list showing only students that failed? Separating it from those who passed

[@rajeshakkineni5127]

Simply superb

[@revolution515]

but what about "Absent" student?

[@notveryc00l]

how u rename the a b c things

[@onteruvikram8451]

its not working for all values =if(C2>35,"pass","fail")

[@muradshaikh7422]

Firstly I want to give rank of the students who have passed then fail. What is the formula?

[@shehzadjan5638]

sir mere sat same marks same rank ha raha hai kindly koi or formula o ga

[@Short_Films709]

Thank you so much for this sir.

[@abhimodel806]

Tq... Super explanation

[@PankajMishra-xg9vf]

Sir, If I want to display the students name based on specified range of marks, how should I do that in excel. Kindly, help me regarding this..🙏

[@aliyukabir9011]

You shall right click between the row that you want put the student's name and click on insert, the option will appear that let you to find a space

[@rajeshakkineni4565]

nice information sir but i have a doubt .. when two students getting same marks then ranks also getting same but coming next rank person getting one rank below.... also i want to given conditions when student getting 400 above ranks on, above350 second rank like that.. how its came

[@bizzle9844]

brother i is confusion!!!!! everyone is failing!!!! what i do?

[@junaidjunaid7999]

Thank you 🙌

[@emmanuelkwesi2387]

That's a great tuition. Thanks so much.

[@gamerzgill8191]

if two students rank same then how this rank formula will work?

[@Fousia22]

Well explained very useful thank you

[@usmansiraj7072]

BRO MA FORMULA SAHI LAGA RHA HU LEKIN AGAR PHELE FAIL LIKHU TU SB KA RESUKT FAIL NIKAL ATA HA OR PASS LIKHU TU SB KA PASS PLZZ HELP

[@uttamdaschelak2380]

sir how to show student status fail pass and 1 sub fail is supply

[@habibriaz5651]

Thank You Sir

[@MuhammadUsmanTaj]

Great really fruitfull tutorial

[@kiranbarru1918]

Sir Nice video, can we give ranks with using if formula, please give reply.

[@katushaberacheal5345]

Best teacher

[@dafodilshub9415]

How to use by $ sign please coul you define?

[@usha6287]

Shift+4

[@hamsaaparajitha970]

Very nice sir

[@ashishparakh8380]

Need a formula I have 2 tabs. In Tab A I have 2 Columns, Column A is named as Students, Column B is named as Pass or Fail. In Tab B I want to see only Passed Students. Help me with some Formula

[@mdmazharulislam5111]

Thanks for video.

[@amroaizawl474]

After one year i knew how to indicate the division of rank...but how can i put Distinction, First, Second, Third... i used this formula but i cannot added THIRD divicion..anyway thank you

[@michaelobiero519]

Nice and clear

[@nazmeenkhan395]

Sir thoda hindi main v boliye ap to aur acche se smjh aye

[@aakritiverma3871]

For Pass and Fail formula, why used 35?

[@pradeepmotivational-g1l]

Sir, the 35 used by him has been done to explain that every state has a passing mark like we are from Bihar, so in our Bihar for 10th class student, 30 Mark is the average to pass.