Extending the earlier set-up ..

Revised sample construct at:
http://www.savefile.com/files/8330144
Creating a list in sequential order_MarkJackson_wks

In sheet: Lost Recap
----------------------
Put in C2, copy down:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"",ROW()))
(Leave C1 empty)

In a new sheet: Summ
----------------------
Put in A2:
=IF(ISERROR(SMALL('Lost Recap'!C:C,ROWS($A$1:A1))),"",
INDEX('Lost Recap'!A:A,
MATCH(SMALL('Lost Recap'!C:C,ROWS($A$1:A1)),'Lost Recap'!C:C,0)))

Copy down to A20
(cover the same range as was done in col C in "Lost Recap")

Put in B2, copy down:
=IF(A2="","",SUMIF('Lost Recap'!A:A,A2,'Lost Recap'!B:B))

Summ will return the final "summarized" results that's wanted

Adapt to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mark Jackson" wrote in message
...
Max,

Thank you for taking the time to look at my post. I like what you have
done
so far. My worksheet might be over 500 lines, would it be possible for
each
company that has won more than one time to be listed just once and add the
total number of bids won and the total dollar value on one line? Thanks
for
your help.

Sincerely,
Mark