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

tinkode

New Member
Joined
Oct 21, 2018
Messages
31
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

 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,255
Office Version
365
Platform
Windows

tinkode

New Member
Joined
Oct 21, 2018
Messages
31
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,255
Office Version
365
Platform
Windows
Yes I can read your thread, but I cannot read your mind ;)
Care to explain what you meant in post#3?
 

tinkode

New Member
Joined
Oct 21, 2018
Messages
31
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,255
Office Version
365
Platform
Windows
Did you try any of the formulae in the link I provide?
If so how did you change them to suit your requirements?
 

Forum statistics

Threads
1,077,855
Messages
5,336,788
Members
399,102
Latest member
chudson1

Some videos you may like

This Week's Hot Topics

Top