i am trying to make excel sheet of bookkeeping and bank statement. now i want sort out all bank transaction when i do any entry in bookkeeping and i gave formula (=IF(Table1[HEAD DR رئيس]="Bank بنك",Table1[AMOUNT DR كمية],"") for deposit & =IF(Table1[HEAD CR رئيس]="Bank بنك",Table1[AMOUNT CR كمية],"") for withdrawal) but they are making problem and not giving result in series. Kindly can anyone here help me....... for review



Month: April,2016 الشهر: أبريل، 2016 0
DATE DEPOSIT WITHDRAWAL CLOSING BALANCE COMMENTS
1/0/1900 SAR - SAR - SAR - 0
1/0/1900 SAR - SAR - SAR - 0
1/0/1900 SAR - SAR - SAR - 0
1/0/1900 SAR - SAR - SAR - 0
1/0/1900 SAR - SAR - SAR - 0
06.04.16 SAR 4.00 SAR 7.00 SAR (3.00) 0
07.04.16 SAR 3.00 SAR 7.00 SAR (7.00) 0