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

tinkode

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

5W3KrPd.png
 
Last edited:

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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
 
Upvote 0
Yes I can read your thread, but I cannot read your mind ;)
Care to explain what you meant in post#3?
 
Upvote 0
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

gj81gCA.png


i want when i filter the date i can see the sum of consumes of Motor fuel
 
Upvote 0
Did you try any of the formulae in the link I provide?
If so how did you change them to suit your requirements?
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top