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

Use the SUBTOTAL function.

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36


"Tarvirdi" <(E-Mail Removed)> wrote in message news:O$(E-Mail Removed)...
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

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

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$22)

and copy it down to e.g. E6

keizi

"Tarvirdi" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>

thanks, it works