# Subtraction a filtered list

#### tinkode

##### New Member
hello kings of excel i want Subtraction filtered list
the first number - the last number

i have many filtered list so i can't use =sum(X1-X2) it will take many times

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

=INDEX(L14:L260,MATCH(1,INDEX(SUBTOTAL(2,OFFSET(L13,ROW(L1:L260),)),),))-L260

not working its show 132880-131710 = -34710

formula for Subtraction for filtered list

Re: formula for Subtraction for filtered list

is your filtered list a table or no?

Re: formula for Subtraction for filtered list

yes

Re: formula for Subtraction for filtered list

are your numbers always in sequence order like they are in the example? Because if so you could probably use the below formula?

Code:
``=SUBTOTAL(4,Table1[Numero])-SUBTOTAL(5,Table1[Numero])``

Last edited:
Please try again, note the Offset OFFSET(M13,ROW(M1:M260),))

Data start at M14

=INDEX(M14:M260,MATCH(1,INDEX(SUBTOTAL(2,OFFSET(M13,ROW(M1:M260),)),),))-INDEX(M14:M260,MATCH(1,INDEX(1/SUBTOTAL(2,OFFSET(M13,ROW(M1:M260),)),)))

=INDEX(M14:M260;EQUIV(1;INDEX(SOUS.TOTAL(2;DECALER(M13;LIGNE(M1:M260); )); ); ))-INDEX(M14:M260;EQUIV(1;INDEX(1/SOUS.TOTAL(2;DECALER(M13;LIGNE(M1:M260); )); )))

Last edited:
you are the king thanks you <3

Happy to help

Replies
4
Views
216
Replies
1
Views
86
Replies
4
Views
108
Replies
4
Views
111
Replies
4
Views
165

1,203,487
Messages
6,055,713
Members
444,810
Latest member
ExcelMuch

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back