correct total column in flitered list

T

Tarvirdi

correct total column in filtered list

Dear friends,

I have a list(table in 2007) as bellow

Serial
Item Code
Import
Export
Remain

1
10
20

20

2
20

10
10

3
10
30

40

4
30
10

50

5
20

20
30



note how last column (remain) is calculated (remain=up remain+import-expor)
if i filter (itemcode) for 10 the remain column value not calculated on new condition (correct calculation but useful for me)
how can I implement last column calculation to get as bellow list?
Serial
Item Code(=10)
Import
Export
Remain

1
10
20

20

3
10
30

50


Thanks
Tarvirdi
 
T

Tarvirdi

Thanks,
But SUBTOTAL is useful for bottom total not for column(remain)
if I mistake please describe and help me to write the function
thanks again
 
K

kounoike

if Import in column C, Export in column D, and Remain in column E,
then put a formula below in E2

=SUBTOTAL(9,C$2:C2)-SUBTOTAL(9,D$2:D2)

and copy it down to e.g. E6

keizi
 
Top