Microsoft Excel

Microsoft Excel Exercise 2 COUNTIF

Photo of Muhammad Niaz Muhammad NiazFebruary 2, 2014
13 11,104 1 minute read

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

5 DAYS ATTENDENCE PAGE
Roll No. Name 1 2 3 4 5 Total Attendance % age Eligibility for Exams
1 Hira P A A P P 3 60 Allowed
2 Bilawal A P P P P 4 80 Allowed
3 Samina P P P P P 5 100 Allowed
4 Rubina P P P P A 4 80 Allowed
5 Aqeel P P A A P 3 60 Allowed
6 Faizan A P P A A 2 40 Not Allowed
7 Madiha P A P P P 4 80 Allowed
8 Erum P A A A A 1 20 Not Allowed
9 Salman P A P P P 4 80 Allowed
10 Nasir P A A P P 3 60 Allowed

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

Photo of Muhammad Niaz Muhammad NiazFebruary 2, 2014
13 11,104 1 minute read

13 Comments

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

    Reply

    1. 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

      Reply

  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)

    Reply

  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

    Reply

  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??

    Reply

  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.

    Reply

Leave a Reply

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

Back to top button