View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default Creating a list in sequential order

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
--