Page 1 of 3 123 LastLast
Results 1 to 12 of 25

Thread: How to count in excel

  1. #1
    shehzad_ktk79's Avatar
    shehzad_ktk79 is offline Senior Member+
    Last Online
    4th November 2014 @ 12:21 PM
    Join Date
    17 Mar 2010
    Posts
    654
    Threads
    55
    Credits
    822
    Thanked
    26

    Default How to count in excel

    hi, frnds me excel me counting krna chahta hon for example mery pas bhut sy items hai jin ko me ne sale kiya hai ab me pory month ka hesaab krna chahta hon lets suppose me ne 1 bill me koi jeez sale ki hai pir wo jiz me ne 4,5 bills k bad 1 or bill me sale ki hai to aisa formul chahta hon jis me 1 he cell me us item ki quantity likon ko automatical 3rd cell me add ho jy lakin jis cell me ne likha hai wo cell zero ho jy ...............

  2. #2
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Kya aap apne expected result ka screen shot d sakte hain. Ya ho sake tu apne sample file upload kar dian ta k samajh ne m asani ho. Agar aap quantity count karna chahte hain tu is k leye countif ka function istimal hota ha. agar apne item wise sale ka total maloom karna chahte hain tu is k leye sumif ka formula istimal hota ha. In dono formulas k leye ap excel ki built in help use karain ap ko wazeh ho gai ga.

    Agar ap apne sample sheet ya screen shot expected result k sath dain tu behtar ho ga.

    regards

  3. #3
    shehzad_ktk79's Avatar
    shehzad_ktk79 is offline Senior Member+
    Last Online
    4th November 2014 @ 12:21 PM
    Join Date
    17 Mar 2010
    Posts
    654
    Threads
    55
    Credits
    822
    Thanked
    26

    Default

    file is attached syar
    Attached Images Attached Images  

  4. #4
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    You can use cell custom formattig to achieve this
    1. Select Cell e.g. A1
    2. Right Click on cell and choose format
    3. from Number category choose custom and paste in type box paste the below formatting.

    Code:
    [<1]#0;"0"
    Ap jab bhe koi value enter karian ga tu cell m 0 he show ho ga aur kuch nahee. Value add hote jain gi.

    regards,

  5. #5
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

  6. #6
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Default

    Quote syar said: View Post
    You can use cell custom formattig to achieve this
    1. Select Cell e.g. A1
    2. Right Click on cell and choose format
    3. from Number category choose custom and paste in type box paste the below formatting.

    Code:
    [<1]#0;"0"
    Ap jab bhe koi value enter karian ga tu cell m 0 he show ho ga aur kuch nahee. Value add hote jain gi.

    regards,


    Pls Check
    http://www.itdunya.com/t309591/
    WSLM::

  7. #7
    shehzad_ktk79's Avatar
    shehzad_ktk79 is offline Senior Member+
    Last Online
    4th November 2014 @ 12:21 PM
    Join Date
    17 Mar 2010
    Posts
    654
    Threads
    55
    Credits
    822
    Thanked
    26

    Default

    Syar bro its not working or ap jo bta rhe ho es me adding processs ni hota

  8. #8
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    http://www.itdunya.com/t300546/
    اس جگہ رابط کریں

  9. #9
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    http://www.itdunya.com/t300546/
    اس جگہ رابطہ کریں

  10. #10
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Bhai m ap ki bat nahee samjha. Kya aap ya tu nahee chahte k faraz karian ka a1 m agar ap 1 lekhain tu us ka total bhe c1 ya kahin aur add hota rahe. Aur jab ap a1 m dobara entry karin yani 2 tu wo bhe a1 ki previous value m add ho yani 3 ho jae aur c1 m bhe total add hota jae.

  11. #11
    shehzad_ktk79's Avatar
    shehzad_ktk79 is offline Senior Member+
    Last Online
    4th November 2014 @ 12:21 PM
    Join Date
    17 Mar 2010
    Posts
    654
    Threads
    55
    Credits
    822
    Thanked
    26

    Default

    Yes exactly syar bhai me ya he chahta hon

  12. #12
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    tu brother asa formula k zarye nahee ho sakta. is k leye macro darkar hogi. ap thoda w8 karo m coding kar k deta hon. wese mere khyal m m n kisi thread m kisi ko answer dya tha pehla wo check karta hon phir batata hon.

Page 1 of 3 123 LastLast

Similar Threads

  1. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  2. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  3. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  4. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •