check value - merge and count

Hello!

I have following problem.
I have a file with about 10,000 rows, each containing a column with a number, a date, text, text, number, number. that order, about 10,000 times.

Now I have the great honor to check all these entries for duplicates (done), BUT, and this is where it gets tricky, some entries values are exactly the same.

Example:

A - B - C - D - E - F
5 - 2009/01/01 - Bill Gates - Microsoft - 5 - 13
5 - 2009/01/15 - Bill Gates - Microsoft - 6 - 17


How do I manage to get Excel to count me that there are 2 entries, and then merge them together into one, but still showing me "2" in another colum?

WANTED RESULT:
A - B - C - D - E - F - H (!)
10 - Date does not matter - Bill Gates - Microsoft - 11 - 30 - TOTAL 2 entries

The date does not really matter and can actually be deleted. Anyway, I have been playing with CountIF but without success. any ideas?

THANKS
A2k

Hi Armitage 2K
Have you tried a pivot table ?

Something like

Please Login or Register  to view this content.

or even more so

Please Login or Register  to view this content.

Ops..two of the sumproducts should have been sum in formula array

Please Login or Register  to view this content.

you'll need to change the sheet number/name to your value

even confused myself
use

Please Login or Register  to view this content.