Excel 2007 : Vlookup with a counting feature?

Column A has an entry everytime I make a sale. Column F has how many I've bought. I need to know if there is a way to have column H lookup the ID from F and count how many times it shows up in A..

I've attached a test page.

thanks..

Is this what you are looking for?

=COUNTIF($A$2:$A$17,F2)

copy down

Alan