I have multiple pages that have 65,536 rows, same monsterous spreadsheet,
138-MEG and I need to lookup data from each and have a summary sheet accept
the returned answers:

Fleet Removal Date Install Date TSI CSI
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189
BMW 06/10/2008 06/10/2005 100:03 189
Ford 06/10/2008 06/10/2003 200:03 289
Chev 06/10/2008 06/10/2002 340:03 389
Olds 06/10/2008 06/10/2006 180:03 129
Suzu 06/10/2008 06/10/2007 50:03 89
Hond 06/10/2008 06/10/2001 1,100:03 1189

I need the return vlookup to get me all of the BMWs, then the Fords, etc.,
and just give me an end result of a count of how many of each, but I need the
TSI and CSI fields to also add up and then average that by the like units:

Fleet TSI CSI
76 BMW 7100:03 5,189
81 Ford 3200:03 3,289
66 Chev 4340:03 389
42 Olds 2180:03 429
21 Suzu 550:03 689
91 Hond 21,100:03 18,189


Can this be done?

Thanks,
Champ