+ Reply to Thread
Results 1 to 12 of 12

calculate the absent of a specific person for whole year

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    calculate the absent of a specific person for whole year

    dear friends,

    its my first visit with all of you. my self dinesh sharma and i am here for sharing knowledge and ideas.

    at present i am searching a better excel formula for counting the total absent in the year for a specific employee.

    can any body help me?


    Dinesh Sharma
    9212247540
    Suraj ki kiran sabko milti hai per dekhta har koi nahi.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    so there is no answer for my first query on this link http://www.excelforum.com/search.php?searchid=113238

    ???

    thanks for no comments.

    now i am uploading a very useful excel sheet for my friends who are working as H.R. or as an Accountant.

    Dinesh Sharma
    9212247540
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: calculate the absent of a specific person for whole year

    Pl see attached file .It may help.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    dear friend,

    thanks for helping me. you are near on the target but my question was that i am searching total counting of absent, present and leave of Mr. anyone (you can choose any name of them from the attached file). for example how many Absents, Present and Leave of Mr. Mohan Singh.


    when you will solve this problem then i will give you a gift. its not a matter of TIT FOR TAT so please dont mind. i am a useful person for everyone.

    with warm regards,
    your new friend.

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: calculate the absent of a specific person for whole year

    Hello , and welcome to the forum.

    Try this:

    =SUMPRODUCT((B4:B80=B20)*(D4:AI80="A")) to get the total # of days absent for the name in cell B20

    Change the B20 to any cell where you want to input the name

  6. #6
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    hello sir,
    thanks for answer and please wait for tying check the answer.
    which kind of experince you want to know? i will help you else excel.

    ---------- Post added at 08:35 PM ---------- Previous post was at 08:34 PM ----------

    hello sir,
    thanks for answer and please wait for tying check the answer.
    which kind of experince you want to know? i will help you else excel.

    with regards,

    your dinesh sharma

    ---------- Post added at 08:40 PM ---------- Previous post was at 08:35 PM ----------

    ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
    respected sir,
    i am not seraching any special cell as per your advise of B20. i am searching the absents presents of any person like asdinesh sharma, ajay or fauran singh.

    why are you not getting my problem???

    am i wrong in speaking or tying in english?

    with to answer from you,
    your's,
    Dinesh Sharma

  7. #7
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: calculate the absent of a specific person for whole year

    Did you read this from my previous post:

    Change the B20 to any cell where you want to input the name
    Pick a cell, any cell you want, and type the name you want to check. Then, in the formula I gave you, change the B20 to the cell where you typed the name.

  8. #8
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: calculate the absent of a specific person for whole year

    Pl see the attached file.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    dear friend,
    i can count the absent of mr. mohan singh by filtering the cell. you can also check that i have already create the formula in AI4, AJ4, Ak4 and in AL4. but i am searching a formula for counting the absent of every person one by one.

    i mean to say that i can filter by name and count the absent present. but i dont like to filter thats why i am searching but i hope there is nothing solution.

    Dinesh Sharma

  10. #10
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    dear friend,

    i have modified your formula and now i am count total absent or total present of anyone in the employees.
    thanks for your co-operation and now i am uploading an excel sheet hope it will be helpful for my all friends.

    Dinesh Sharma
    Attached Files Attached Files

  11. #11
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: calculate the absent of a specific person for whole year

    @ dinesh4you

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

  12. #12
    Registered User
    Join Date
    08-06-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: calculate the absent of a specific person for whole year

    dear friend,

    thanks for guidance about rules.

    i am new in this for forum. i will keep it mind and again thanks for help.

    God bless you.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1