sum & subtract for the same column based on two values

[Alaa mg]

hi
I have many amounts in column B for each DEBIT,CREDIT in column A so I PUT the result and simple formula in column D , but i need calculation on process does based on DEBIT , CREDIT and I put the value in first row "opening" .this case is not always existed . somtimes not existed .may be you just find startting debit or credit . so the calculation should take value in column B for "opening" if there is existed and sum the amount for debit and subtracrt from credit . and if there is no opening then should sum the debit and subtract from credit . so should sum or subtract from the first and to next .
the formual should be like this when calaculate the amounts = opening+debit-credit in column D .

aaaa.xlsx
	A	B	C	D
6	MOVING	AMOUNT	DESCRIPTION	BALANCE
7	OPENING			1,000.00
8	DEBIT	1,000,000.00		1,001,000.00
9	DEBIT	200,000.00		1,201,000.00
10	CREDIT	50,000.00		1,151,000.00
11	DEBIT	1,000,000.00		2,151,000.00
12	DEBIT	500,000.00		2,651,000.00
13	CREDIT	800,000.00		1,851,000.00
14
mv

Cell Formulas
Range	Formula
D11:D12,D8:D9	D8	=D7+B8
D10,D13	D10	=D9-B10

Cells with Data Validation
Cell	Allow	Criteria
A14:A20	List	=$E$1:$E$2

 

[AlanY]

try this in D8 and copy down

=D7+IF(A8="DEBIT",1,-1)*B8

 

[Alaa mg]

thanks very much

 

[AlanY]

thanks very much

you're welcome