YouTube Subscribe Animation Button

Microsoft Excel Exercise 2 COUNTIF

Microsoft Exersice 2 COUNTIF

In this video Learning tutorial you can learn how to Create attendance sheet in Microsoft Excel 2013 in Urdu and Hindi Language and you can also learn How to Calculate Total Attendance using COUNTIF Function, How to Calculate Percentage and Calculate Eligible and Not Eligible using IF Function.

COUNTIF

  • YouTube
  • Vimeo 
5 DAYS ATTENDENCE PAGE
Roll No.Name12345Total Attendance% ageEligibility for Exams
1HiraPAAPP360Allowed
2BilawalAPPPP480Allowed
3SaminaPPPPP5100Allowed
4RubinaPPPPA480Allowed
5AqeelPPAAP360Allowed
6FaizanAPPAA240Not Allowed
7MadihaPAPPP480Allowed
8ErumPAAAA120Not Allowed
9SalmanPAPPP480Allowed
10NasirPAAPP360Allowed

Microsoft Excel Home Page
Watch, Learn and Share with Your Friends

Check Also

Microsoft Excel Exercise 4 Payroll

Download Setup In this video learning tutorial you can learn How to Create a Pay Roll …

13 comments

  1. Assalam O Alikum sir kya ap moj ko 15% discount niklnai ka metter bata saktai hai please

    • Walikum Salam Dear Agar ap ye 10 Exercise Dekh lenge to ap ko Kabhi Problem Pesh nahi aye ge
      15% ko aisi Nikale ge
      =15/100*jis ka Nakalna ho wo Yahan Likhe and Enter ker de Excel main
      Jaisi 450 ka 15% Nikalna hai
      =15/100*450

  2. Thanks for your efforts
    Muje ek sawal poochna hai k agar mein time sheet banata hu or agar muje time in (i.e. 09:40) and time in dead line (i.e. 09:30) ko calculate ker ke result lana ho tou konsa formula use hoga or kaisay use hoga, q k muje result chahiyee seperate colume mein i.e. (10 mins, late time calculation kerna chahata hu total)

  3. thanks sir bohat helpful lesson hai ap se ek request hai [ attends quetion, Scholarship , Mark sheet ]
    en 3no ka Hlookup Yan Vlookup b add kr dein Thanks waiting for ur replY

  4. hello sir,
    sir aap esi tharha sath rhna hmasha sir me aapka bahoot bra fan hu.

  5. Asslam-o-Alikum Brother.. ap ne btaya ni k ksi b file ko highly compressed kis trha krty hian?? i mean 10gb ko 1GB main kis trha compressed krean??

  6. salam bhai jaan ! main puchna ye chahta hu k ap itnay ziada file hosts pr aik hi files ko upload kaise krte hain. hm to aik file b uploading pr lga dain to boht time lgta hai. agr ap k pas is ka koi short cut hai yani upload jaldi jaldi krne ka to plz hmain b bta dain. very very thanks in advance.

  7. sallam
    ap nia domian kon ci site sia li hia pls mujy batay or ap ess kia kitny piasy daity hia

  8. can you please upload ea sports cricket 2007 in resumable site

Leave a Reply to Arslan Cancel reply

Your email address will not be published. Required fields are marked *