check multiple columns data & give result

Hi,

I HAVE A SHEET IN WHICH I HAVE 6 COLUMNS FOR RICE INVENTORY.

1)Report No
2)IN/OUT/PROCESS/Fg(This column show whether Rice In, out,Proceeds & Finshed goods)
3)Product Name
4) In (If In & FG i have make entry of quantity in this column)
5) Out (If out or process i have make entry of quanitity in this column)
6) Balance

Now i want that balance column check the report number, product name , & whether it is IN OUT Or other so it give me balance


If it is IN or FG so it add or if it out or Process its less it.