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
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
Ok I upload it soon..................
Well, See You Soon.
Dear Ghayyas
File is not going to be upload here
Last edited by Sahil_Jaan; 24th May 2015 at 06:11 PM. Reason: ای میل مانگنا منع ہے
آپ فائل کو کسی بھی سائٹ پر اپلوڈ کر دیں اس کا ڈاونلوڈ لنک یہاں پوسٹ کر دیں یہ سائٹ ہے یہاں اپلوڈ کر دیں
www.datafilehost.com
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
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.
i Cant Acces Your File, So Please Upload On Datafilehost.com or Give Me Acces ToYour GDrive Files. Thanx
Dear Ghayyas,
NOw you Can Access the file
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
OK, SAMJH GAYA,
work kar ke update karta hoon
Last edited by Ghayyasg; 31st May 2015 at 02:26 PM.
Bookmarks