This assumes you record all private mileage with the same phrase, 'private'

https://s16.postimg.org/91o6p7ejp/mileage_totals.png

The formula in O9 (the Private mileage weekly subtotal) is;
...