Hi Friends,
In the attached file, what I want is to know how much total purchases have been made from each supplier, how can I do so, any formula ?
4 Replies
Anandan
(HOD accounts)
(502 Points)
Replied 16 December 2013
Respected Vaibhav,
you can take the help of Pivot table, to extract the desired details from the datasheet.
Please find attached the same.
Thanks & Regards
Anandan.s
Attached File : 853193 1260984 450147 1260974 daybook.xlsx downloaded: 174 times
Amrin
(Chartered Accountant)
(215 Points)
Replied 16 December 2013
Apply "FILTERS" in the cell , right click the "Particulars" tab and then select filters.. u can then select any one company from the dropbox and you will get all the individual purchases from that party,
P.S you "AMT" is not correct, in some place the amount is inserted in a way which excel doesnt recognize and hence you sum total will come wron.. so correct that!
Rajesh
(student)
(193 Points)
Replied 16 December 2013
Dear Vaibhav,
Here with i attached your Excel sheet.
I have added Subtotal Formula. ( I have highlighted with Yellow Color).
This subtotal formula will give purchase details of the individual.
Formula of Subtotal =Subtotal(9,select the range)
Attached File : 78813 1260997 450147 1260974 daybook.xlsx downloaded: 192 times
Vaibhav Jandey
(Life iz Hard; I'm Harder)
(1175 Points)
Replied 16 December 2013
Thank you friends for your replies, Anandan you gave me what I was looking for.
Join our off-topic community "EVERYTHING etc" for ultimate leisure, fun and etc.
Recent Topics
- ITC reversal in GST 3B
- Claim if ITC on stocks 19-2020 conversion from com
- Urgent doubt on GST
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
- Income tax on freelance income from crypto
Related Threads
CAclubindia
