Thanks Max!

It works perfect. I appreciate your time and effort.

Sincerely,
Mark

"Max" wrote:

total number of bids won

Missed out the above requirement earlier, sorry

In sheet: Summ
----------------------
Put in C2, and copy down:
=IF(A2="","",COUNTIF('Lost Recap'!A:A,Summ!A2))

Col C will return the total # of bids won for the companies extracted in col
A

The previous sample has been amended:
http://savefile.com/files/8330144
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--