Thanks so much, that is exactly what I need. Could I be a pain and ask you to manipulate the workbook so 'car,van,truck' is across the top and the months are down the side?
Sorry; I am newish to Excel and still trying to get my head around formula manipulation.
If you could do that it would be greatly appreciated!