EDIT - I see you just posted to say you've got it working - great to hear that.
So ignore the rest of this post, although you might look at the note at the end about posting data.
I don't understand where the L22, M22 & N22 values are coming from
I said in my response: I created a table of values to go into cells L23 to N27
Each row contained the data for the group, as follows:
This should have said L22 to N27
This table provides the source parameters for the formulas to work on.
500 & 9999 is just one way of identifying mileage of 500 miles and more.
By using a table, I was able to use one formula that could be dragged down in column K from K22 to K27.
Each formula could have been different - each containing V or RT and the mileage values such as >500.
The table approach just simplified the way the formulas were created.
Using the mileage and vehicle type data from your last post, (column F & I and rows 10 to 16, this is what I got:
A ... K
22 Mileage - Vans >500 miles 746
23 Mileage - Vans 425 - 500 mi 435
24 Mileage - Vans <425 miles 373
25 Mileage - Roll Tite >500 m 1181
26 Mileage - Roll Tite 425 - 500 497
27 Mileage - Roll Tite <425 m 311
Are these results correct?
Please, if posting data, to help line up columns, put your data between <pre> and </pre> tags that you can insert using the 'Pre' icon above the reply box. Then use the Preview button and edit as required. To preview again, check the 'Check To Show Confirmation Page Again' box and click 'Confirm and see post'