Results 1 to 10 of 10

Thread: Need Count formula help in Excel (advance thanks)

  1. #1
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default Need Count formula help in Excel (advance thanks)

    Assalam o alikum!

    Friends maine ya sheet banayi ha agar app iski summary mai jaein to sab ka total
    a raha hain, ab mai chahta hoin ka har cell mai mai jo b amount dalo wo count b hoin!
    mean in summary total amount ka sath total figure b aya ka kitna cell mai amount dali gayi hai!
    background: Mai aik Money exchange mai kam karta hoin! to baki exchanges ka sath inter branch business hota hai wo hama receipt bhejta hian!
    mai un receipt ka total lagata hoin!
    to mai chahta hoin ab summary mai total number of receipt b ajein!
    Thanks in advance for the help!
    link for file :http://www.mediafire.com/?apaq06ukr2apib6

  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

    salam;;

    i'm not sure but try in summary sheet
    D9
    Code:
    =COUNTIF(SEND!P6:P49,"<>0")
    change sheet name and ranges accordingly.

    regards

  3. #3
    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

    Please check the attached file and study the formulas use in this sheet alongwith the named ranges and a table. Then discuss if u have a problem.
    To upload your file i have deleted the some sheets.


    regards,
    Attached Files Attached Files

  4. #4
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default

    Quote syar said: View Post
    Please check the attached file and study the formulas use in this sheet alongwith the named ranges and a table. Then discuss if u have a problem.
    To upload your file i have deleted the some sheets.


    regards,
    Bhai ap na to sab ka sab main item delete kar diya hain!

  5. #5
    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

    Quote hashibhai111 said: View Post
    Bhai ap na to sab ka sab main item delete kar diya hain!
    Brother m n sheet attached karne k leye delete keye hain aur ap ka samjhane k leye formula lagae hain. Orignial sheets tu ap ka pas hoge na us par formula apply kar lain. Mera maqsad ap ko guidance dena ha. Aap in ko apni original sheet par apply kar lain. Phir agar koi masla ho tu bataye ga. Dosre bat agar ap excel m calculation karna chahte hain tu merge cell kam sa kam istimal karain ap ko faida

    Regards,

  6. #6
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default

    Quote syar said: View Post
    brother m n sheet attached karne k leye delete keye hain aur ap ka samjhane k leye formula lagae hain. Orignial sheets tu ap ka pas hoge na us par formula apply kar lain. Mera maqsad ap ko guidance dena ha. Aap in ko apni original sheet par apply kar lain. Phir agar koi masla ho tu bataye ga.

    Regards,
    sayar bhai app dehan sa dekhan maine original file aatched ki hai!
    Muja samaj nahi arahi to yahan share ki hai!
    App kinldy full file mai formula laga kar muja kahien aur upload karka link da dain!
    Thanks!

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

    Quote hashibhai111 said: View Post
    Bhai ap na to sab ka sab main item delete kar diya hain!
    Quote hashibhai111 said: View Post
    sayar bhai app dehan sa dekhan maine original file aatched ki hai!
    Muja samaj nahi arahi to yahan share ki hai!
    App kinldy full file mai formula laga kar muja kahien aur upload karka link da dain!
    Thanks!
    Bhai mera kahi aur upload sites pa account nahee ha. Aap aisa karain k jo post #2 m m ne apko formula deya ha sirf is ko copy kar lain. aur sheet name aur ranges change karte jain. Ap ka masla hal ho jai ga.

    regards,

  8. #8
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default

    Quote syar said: View Post
    Bhai mera kahi aur upload sites pa account nahee ha. Aap aisa karain k jo post #2 m m ne apko formula deya ha sirf is ko copy kar lain. aur sheet name aur ranges change karte jain. Ap ka masla hal ho jai ga.

    regards,
    app yahan upload kar dain!
    www.mediafire.com

  9. #9
    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 apne origional summary sheet k D9 m ye formula lagain

    Code:
    =COUNTIF(SEND!P6:P49,"<>0")
    Aur ye batain k ap yehe result chahte hain

  10. #10
    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

    Dear Brother,

    Please check the attached file jo k ap na post number 1 m attached ki ha. Pehle is ko pora study karain. aur dekh kar batain k kya ap ka matlooba result ye he ha. agar nahee tu thoda sa wazeh karain. Agar ye he result ha tu phir formulas par bat karte hain.

    http://www.mediafire.com/?407ueo43a63ekye

    regards,

Similar Threads

  1. Solved Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 10
    Last Post: 26th January 2012, 08:48 PM
  2. What is Excel Formula for Difference in Two Values ?
    By Baazigar in forum Ask an Expert
    Replies: 2
    Last Post: 30th May 2011, 09:45 PM
  3. Excel formula main help chahyee
    By sittarah in forum Ask an Expert
    Replies: 5
    Last Post: 8th October 2009, 10:52 PM
  4. VTC - Microsoft Excel Automation - Advance Course
    By oralover2006 in forum General Discussion
    Replies: 13
    Last Post: 5th June 2009, 05:56 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
  •