# Search:

Type: Posts; User: tinkode; Keyword(s):

Page 1 of 2 1

1. ## Thread: COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

by tinkode
Replies
7
Views
149

### Re: COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

my society have 100 cars with different Motor fuel ( 3 types )

-Diesel fuel
-gasoline
-Diesel 50

-every day they consumes Motor fuel
- I want to divide the Motor fuel so i can see consumes...
2. ## Thread: COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

by tinkode
Replies
7
Views
149

### Re: COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

i have list of cars with Vehicle registration plate each car have a different motors fuel and litres consomation every day
so when i filter the day i can see the total...

by tinkode
Replies
7
Views
149

not working
4. ## Thread: COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

by tinkode
Replies
7
Views
149

### COMBINE SUM IF with subtotal to calcul Motor fuel of filter Car Numbers

Hello kings i want to to combine ( sum if with subtotal ) to calcul consomation of Motor fuel

so when i filter a car number it can calculate
Gasoline
Diesel fuel

exemple in picture
...
5. ## Thread: formula to calculate sum of repeated text

by tinkode
Replies
6
Views
252

### Re: formula to calculate sum of repeated text

thanks you fluff
6. ## Thread: formula to calculate sum of repeated text

by tinkode
Replies
6
Views
252

### Re: formula to calculate sum of repeated text

its not problem about the column i will change them
7. ## Thread: formula to calculate sum of repeated text

by tinkode
Replies
6
Views
252

### formula to calculate sum of repeated text

hello i want a formula to calculate sum of repeated text

exemple when i put the text its search in table and find the repeated text and calculate the sum

like in the picture
...

by tinkode
Replies
2
Views
103

### Re: control your sheets data filter with one sheet

uppp plz help

by tinkode
Replies
2
Views
103

### control your sheets data filter with one sheet

i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them

Exemple like in the picture
...

by tinkode
Replies
1
Views
118

### control your sheets data filter with one sheet

Hello Kings of excel

i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them

Exemple...
11. ## Thread: filter the content of an excel sheets from another sheet in the same workbook

by tinkode
Replies
3
Views
248

### filter the content of an excel sheets from another sheet in the same workbook

I would like to filter the contents of Excel sheets In another sheet

I have 5 cells I want each cell is connected by its sheet so i can filtre them without getting back to other sheets
...
12. ## Thread: Formula to display the contents of the first filtered cell

by tinkode
Replies
3
Views
155

### Formula to display the contents of the first filtered cell

Hello kings i want

A Formula to display the contents of the first filtered cell

Exemple like this pic

https://i.imgur.com/yFKrNyJ.png
13. ## Thread: subtraction for subtotal

by tinkode
Replies
1
Views
132

### subtraction for subtotal

hello i dont want to count the first cell for every filtred cell

i tried

=SUBTOTAL(109,Y21:Y261)-SUBTOTAL(109,FIRST CELL )
but dosent work

i dont want to count the first cell
...
14. ## Thread: Formula to display the contents of the first filtered cell

by tinkode
Replies
2
Views
157

### Formula to display the contents of the first filtered cell

Hello kings i want

A Formula to display the contents of the first filtered cell

Exemple like this pic

https://i.imgur.com/yFKrNyJ.png
15. ## Thread: Show number with filter

by tinkode
Replies
6
Views
232

### Re: Show number with filter

working for the first filtre

https://i.imgur.com/azkoGVp.png

when i select another filtre dosent work
16. ## Thread: Show number with filter

by tinkode
Replies
6
Views
232

### Re: Show number with filter

yes its show the first filtre its working but when i select another filtre its not showing

by tinkode
Replies
6
Views
232

not working
18. ## Thread: Show number with filter

by tinkode
Replies
6
Views
232

### Show number with filter

hi kings I would display the numbers filtered in this area of the text
I want when I filter each number is displayed in this area ( see the picture ) thanks you all i love
...

by tinkode
Replies
2
Views
391

### Re: Excel remove Leading zeros in Excel

https://i.imgur.com/Keb3UOa.png

by tinkode
Replies
2
Views
391

### Excel remove Leading zeros in Excel

https://i.imgur.com/WxC0JNR.png
21. ## Thread: Subtraction a filtered list

by tinkode
Replies
15
Views
665

### Re: Subtraction a filtered list

its working for all numbers
but the probleme with the first one 261544-205150 = 55878

https://i.imgur.com/WV9RW5K.png

its should be 56394
22. ## Thread: Subtraction a filtered list

by tinkode
Replies
15
Views
665

### Re: Subtraction a filtered list

can you poste the old replay its was working
23. ## Thread: Subtraction a filtered list

by tinkode
Replies
15
Views
665

### Re: Subtraction a filtered list

you are the king thanks you <3
24. ## Thread: formula for Subtraction for filtered list

by tinkode
Replies
2
Views
191

### formula for Subtraction for filtered list

hello kings i want a formula to Subtraction two numbers

so when i change my filtered list the forumla can do that automatically

Exemple

261544 - 205150 =

https://i.imgur.com/SqWfslz.png
25. ## Thread: Subtraction a filtered list

by tinkode
Replies
15
Views
665

### Re: Subtraction a filtered list

not working its show 132880-131710 = -34710

https://i.imgur.com/3WnhlHc.png
Results 1 to 25 of 29
Page 1 of 2 1