Considereing the file you are using, you could, for the purpose of
producing your report, copy the worksheet, block-remove all Merge Cells
(by selecting All Data, and rightmouse Format Cells, and untick the
Merge)

Then select Column I (Year-Model) and select Data, Sort and sort over
column I

Then select column I and click Data, Subtotals, and select the Count
function.

On the sub-totalled display Click the number 2 shown as the column
header (to the left of the A for column A) and the numbers you require
will be displayed.
You may need to make column I right-alligned, and column J left
alligned for that report.


Hope this helps


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=384179