Results 1 to 4 of 4

Thread: Choti se Problem Excel Expert ke Leye

  1. #1
    kamibest's Avatar
    kamibest is offline Senior Member+
    Last Online
    21st January 2016 @ 10:21 PM
    Join Date
    20 Oct 2008
    Location
    karachi
    Age
    37
    Gender
    Male
    Posts
    1,320
    Threads
    134
    Credits
    960
    Thanked
    81

    Default Choti se Problem Excel Expert ke Leye

    Maine Aik sheet Attach Ki Hai Jis Mai 2 Colum hai (1, Company ka 2 Payment )

    1) Ab Mai Chahta ho Ke Payment ke Colum ke barabar Mai aik summury banjay ke A Company Ki Itni Payment B Comapny Ki Payment hai

    2) Is ke allawa mai chahta ho ke Payment ke Colum ke barabar Mai aik summury banjay ke A Company Ki Itni patyment quantity hai isi tarha B Ki Bhi


    Please solve my Problem
    Attached Images Attached Images  
    Attached Files Attached Files

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Aap attached file m apna solution deekh sakte hain main ne two solution
    deye hain jo aapko pasand aae istimal kar sakte hain. Quantity k liye bhe
    main ne aik sat kar diya hain agar aap chahte hain tu is ko alag column main
    bhee count kar sakte hain.
    Lenkan apne screen shot me jo data diya hai wo app ke file k data se mukhtalif ha. Is matter ko khod deekh lejeya ga.
    2nd aap apne data column ko aik jesa format karain. Agar aik entry column main text ha tu baqi entries bhe text hone chaheye warna aap ke formula error dain ge.

    Umeed rakhta hon k aap ka masla hal ho jae ga.

    Thanks & regards
    Attached Files Attached Files

  3. #3
    kamibest's Avatar
    kamibest is offline Senior Member+
    Last Online
    21st January 2016 @ 10:21 PM
    Join Date
    20 Oct 2008
    Location
    karachi
    Age
    37
    Gender
    Male
    Posts
    1,320
    Threads
    134
    Credits
    960
    Thanked
    81

    Default

    Quote syar said: View Post


    Aap attached file m apna solution deekh sakte hain main ne two solution
    deye hain jo aapko pasand aae istimal kar sakte hain. Quantity k liye bhe
    main ne aik sat kar diya hain agar aap chahte hain tu is ko alag column main
    bhee count kar sakte hain.
    Lenkan apne screen shot me jo data diya hai wo app ke file k data se mukhtalif ha. Is matter ko khod deekh lejeya ga.
    2nd aap apne data column ko aik jesa format karain. Agar aik entry column main text ha tu baqi entries bhe text hone chaheye warna aap ke formula error dain ge.

    Umeed rakhta hon k aap ka masla hal ho jae ga.

    Thanks & regards


    Good

    Leken Quantity ka Formula Dekhe Ye Kaha se Lagraha hai
    Attached Images Attached Images  

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post

    Quote kamibest said: View Post
    Good

    Leken Quantity ka Formula Dekhe Ye Kaha se Lagraha hai
    salam::
    Sorry main bhool gaya. aap F1 main ye formula lekhain.

    =COUNTIF($B$4:$B$30,E1)

    aur copy neeche tak kar dain. Sumif k function main bhee aap 1st cell se he references absolute kar lain tu aap ko mushkil na ho ge. Attach file main sumif formula ko bhee edit kar dain

    =SUMIF($B$4:$B$30,K4,$C$4:$C$30)
    aik baat phir kehna chahta hon k aap "B" column ko aik jesa format karain.

Similar Threads

  1. aik choti si old tip ufone ki ap k leye
    By A wahab ktk in forum General Mobile Discussion
    Replies: 29
    Last Post: 1st November 2014, 03:46 PM
  2. Answered Expert Yha A Jae Tori Dair K Leye
    By Ayoubkhan in forum Solved Problems (IT)
    Replies: 3
    Last Post: 19th July 2014, 07:13 PM
  3. (::Expert please choti si help krna please::)
    By Kungfumaster in forum Mobile phones problems and Help Zone
    Replies: 9
    Last Post: 8th September 2013, 11:16 PM
  4. Excel Problem... Expert pls
    By Adeawan in forum Ask an Expert
    Replies: 3
    Last Post: 1st October 2012, 03:00 PM

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
  •