Need multiple duplicate rows summed into one row for each product/version, delete dups

Goal: take more than 5K rows of multiple similar items in spreadsheet, combine count of matching sets (Product Name and Product version) into one row, then remove all matching duplicate rows. There will be an unknown number of rows for each software package. There will be multiple similar Product names with varying Versions. Each version needs a summary row. I have no idea of how many products or versions exist within the master file. This task will have to be repeated many times over the next year.

There are three columns. Column titles are: A Product Name, B, Product version, C numerical count

A sample file is attached, with about 200 lines in it.

Example 1:
Windows OS, Version 6.1.7601.17514, 23
Windows OS, Version 6.1.7601.17514, 52
Windows OS, Version 6.1.7601.17514, 19
Windows OS, Version 6.1.7601.17514, 47
Windows OS, Version 6.1.7601.17514, 33

Update or Replace last row, delete all other matching rows.

Summary Row: Windows OS, Version 6.1.7601.17514, 174

Example 2:

Microsoft(R) Connection Manager, 7.02.7600.16385, 41
Microsoft(R) Connection Manager, 7.02.7600.16385, 37
Microsoft(R) Connection Manager, 7.02.7600.16385, 52
Microsoft(R) Connection Manager, 7.02.7600.16385, 19
Microsoft(R) Connection Manager, 7.02.7600.16385, 23
Microsoft(R) Connection Manager, 7.02.7600.16385, 33
Microsoft(R) Connection Manager, 7.02.7600.16385, 61
Microsoft(R) Connection Manager, 7.02.7600.16385, 28
Microsoft(R) Connection Manager, 7.02.7600.16385, 7

Summary Row: Microsoft(R) Connection Manager, 7.02.7600.16385, 301