Help-in Summarizing Report

[Basanta]

hello there !!

Need your kind help.
Scenario:
I have to prepare a stock balance/summary report on weekly basis.

Required:
An automatic balance value from the data provided .

Please suggest an appropriate/fast method to summarize the data, no matter which method !!

Link of the file :

https://drive.google.com/open?id=0Bx4hkkQYYt6uLWtEdHoxejB2cXM

https://drive.google.com/open?id=0Bx4hkkQYYt6uLWtEdHoxejB2cXM

Thanks in Advance !!

 

[SpillerBD]

You can us a Pivot Table utilizing calculated field.

 

[Basanta]

I need a summary of the report (balance) on different sheet if u have gone through the link file.which couldn't be solved through the pivot tables.However, my problem is solved now,after playing lots of formulas in excel, got the best using "sumif"Any way thanks !!

 

[SpillerBD]

"Couldn't be soled through the Pivot Tables...." ?
See Pivot Table solution at https://onedrive.live.com/redir?resid=B4DEBBB920EEBAEB!13796&authkey=!AFctGWyhhuAjY68&ithint=file%2cxlsx

 

[Basanta]

Thanks !!
but the problem has been solved now already as i posted before !!!