correct total column in flitered list

  • Thread starter Thread starter Tarvirdi
  • Start date Start date
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
 
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/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36


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$2:D2)

and copy it down to e.g. E6

keizi
 
Back
Top