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

[tinkode]

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

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel-questions/509428-sumif-countif-visible-cells-only.html

 

[tinkode]

not working

 

[Fluff]

why not

 

[tinkode]

can you read my theard
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 consomation of diffenrt motor fuel type and Vehicle registration plate

 

[Fluff]

Yes I can read your thread, but I cannot read your mind
Care to explain what you meant in post#3?

 

[tinkode]

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

here is the list of car

i want when i filter the date i can see the sum of consumes of Motor fuel

 

[Fluff]

Did you try any of the formulae in the link I provide?
If so how did you change them to suit your requirements?