Page 1 of 2 12 LastLast
Results 1 to 12 of 24

Thread: Need Help Regarding the sumif Formula

  1. #1
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default Need Help Regarding the sumif Formula

    Dear All,
    I have made a Cash book in Excel but i don't know how to use Sumif formula to get the account wise total i don't know how to apply Sumif Formula please any body help me .............
    Please any body Do it for me need urgently.... Thanks

  2. #2
    Ghayyasg's Avatar
    Ghayyasg is offline Advance Member
    Last Online
    8th July 2021 @ 08:27 PM
    Join Date
    13 Oct 2012
    Location
    @ITDUNYA.COM
    Age
    31
    Gender
    Male
    Posts
    1,092
    Threads
    44
    Credits
    1,192
    Thanked
    148

    Default

    I can Do It,
    But I need A Sample File To Know Your Actual Requirements...
    Please Upload A File..

    Waiting
    Visit My Threads And Give Comments
    1 2 3 4

  3. #3
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default

    Ok I upload it soon..................

  4. #4
    Ghayyasg's Avatar
    Ghayyasg is offline Advance Member
    Last Online
    8th July 2021 @ 08:27 PM
    Join Date
    13 Oct 2012
    Location
    @ITDUNYA.COM
    Age
    31
    Gender
    Male
    Posts
    1,092
    Threads
    44
    Credits
    1,192
    Thanked
    148

    Default

    Well, See You Soon.

  5. #5
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default

    Dear Ghayyas


    File is not going to be upload here
    Last edited by Sahil_Jaan; 24th May 2015 at 06:11 PM. Reason: ای میل مانگنا منع ہے

  6. #6
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    آپ فائل کو کسی بھی سائٹ پر اپلوڈ کر دیں اس کا ڈاونلوڈ لنک یہاں پوسٹ کر دیں یہ سائٹ ہے یہاں اپلوڈ کر دیں
    www.datafilehost.com

  7. #7
    Ghayyasg's Avatar
    Ghayyasg is offline Advance Member
    Last Online
    8th July 2021 @ 08:27 PM
    Join Date
    13 Oct 2012
    Location
    @ITDUNYA.COM
    Age
    31
    Gender
    Male
    Posts
    1,092
    Threads
    44
    Credits
    1,192
    Thanked
    148

    Default

    Apki file mays be xlsx format me ho, ap usko open kar k save as karain, aur save as type option me se excel 97-2003 workbook select karain, phir us file ko upload karain, upload ho jaye gi,
    SCREENSHOT DAIKH LAIN

    THANKS
    Attached Images Attached Images  

  8. #8
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default Petty Cash Book

    https://drive.google.com/open?id=0B2...NDA&authuser=0

    Dear Ghayyas
    If you think there will be changes to Petty Cash Book. You are allowed to do so. and if you can please also try to make this Petty Cash Book VBA Userform.

  9. #9
    Ghayyasg's Avatar
    Ghayyasg is offline Advance Member
    Last Online
    8th July 2021 @ 08:27 PM
    Join Date
    13 Oct 2012
    Location
    @ITDUNYA.COM
    Age
    31
    Gender
    Male
    Posts
    1,092
    Threads
    44
    Credits
    1,192
    Thanked
    148

    Default

    i Cant Acces Your File, So Please Upload On Datafilehost.com or Give Me Acces ToYour GDrive Files. Thanx

  10. #10
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default

    Dear Ghayyas,

    NOw you Can Access the file

  11. #11
    gentle is offline Senior Member+
    Last Online
    4th November 2015 @ 02:32 PM
    Join Date
    26 Jul 2013
    Location
    Rawalpindi
    Gender
    Female
    Posts
    44
    Threads
    13
    Credits
    0
    Thanked
    2

    Default

    Mujhe aik tou es mein yeh function chaey k jb mein Accounts Head kaname likhou kisi row mein tou tou Sub Accounts Head category khud ba khud aa jaey. for example mein type krti houn MOBILE CARD EXP. tou sub account mein jis ko mobile card provide keyia gya hai uska name aa jaey e. g MR. A or Mr. B pori expenses list na aye Sub Accounts Head category ke colum mein bilkay only relevant sub category aye .
    and report of daily expenses sheet mein account wise total aye aur category wise total aye

  12. #12
    Ghayyasg's Avatar
    Ghayyasg is offline Advance Member
    Last Online
    8th July 2021 @ 08:27 PM
    Join Date
    13 Oct 2012
    Location
    @ITDUNYA.COM
    Age
    31
    Gender
    Male
    Posts
    1,092
    Threads
    44
    Credits
    1,192
    Thanked
    148

    Default

    OK, SAMJH GAYA,
    work kar ke update karta hoon
    Last edited by Ghayyasg; 31st May 2015 at 02:26 PM.

Page 1 of 2 12 LastLast

Similar Threads

  1. How to remove Formula Link in Excel.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 1
    Last Post: 4th April 2016, 12:28 PM
  2. minus 1 formula kya hai?
    By muhammad_adnan in forum General Knowledge
    Replies: 6
    Last Post: 27th March 2015, 11:49 PM
  3. Replies: 20
    Last Post: 15th May 2014, 01:05 PM
  4. Solved Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 10
    Last Post: 26th January 2012, 08:48 PM
  5. Ye kis tarha ke formula hote hai-
    By Nadeem Ahmed Kh in forum Solved Problems (IT)
    Replies: 9
    Last Post: 28th July 2010, 06:01 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
  •