KM traveled per month, per car

Hello everyone! is my first post
well, i've been working on this database (see down): it's a database containing the kilometers traveled by car, so you have: Column1: the date that the measurement was made, Column2: the vehicle registration plate and in column 3, the km measured in the point of time by vehicle;

So, What i need is a formula to calculate the km traveled per month, per car
For example:

Date Car Plate Kilometers
7/4/2018 PCH8907 100
7/9/2018 PCH8907 105
7/16/2018 PCH8907 110
7/24/2018 PCH8907 115
7/29/2018 PCH8907 120
8/2/2018 PCH8907 125
8/10/2018 PCH8907 130

In this case, the car PCH8907 traveled 20km in July 2018 and 10km in august.


I've been trying everything, but i hadn't had success so far

I'm desperate..
Pls help me.


Thank you very Much! waiting to see responses

(Note: the database i'm showing you is just an example), real database has 200 cars and 12 months data.


Edit! Thank you all for the help! I used a Pivot Table to see max and min values per month, and then just substracted it. Thank you

Are you open to using a pivot table?
EDIT - Sorry I thought you wanted the sum of kilometers...ignore pivot table.

Attach your sample workbook...

Go Advanced -> Manage Attachments -> Upload

Take a look at using SUMIFS()

Formula wise I take the Kilometers to be cumulative odometer readings.

With a helper column D for miles between odometer readings. Try this array formula in E2 and filled down.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Or in same workbook column E this non array formula.

Formula:

Please Login or Register  to view this content.