How can i use SUMIFS

Hello Sir,

Sir, Which formula to be use in my given Query

i create one data entry book in the work book there are 3 sheets named with List, Dispatch Register and BP & GP

in the List sheet i enter the party name with their opening balance

in the Dispatch Register i enter the party lifting details

In BP & GP Sheet i want the balance of the party with Brand Wise

so for that above features i use the formula as (SUMIFS) but i am fail to get the result so kindly suggest me to which formula to be use

Hence i oblige, for your better information i give a link for my file

https://dl.dropbox.com/u/75654703/Reports.xlsm

With Regards

patnaik