Merging Specific Value of Specific rows and columns

[HIT1K]

I have an excel sheet that has multiple instances of names but different values in columns Example:
C1 C2 C3 C4 C5
R1 ABCCD 500 0 0 500
R2 ABCCD 0 16 0 16
R3 ABCCD 0 0 8 8

Is there a way to combine these 3 rows in this way Example"

C1 C2 C3 C4 C5
R1 ABCCD 500 16 8 524

[CheshireCat]

You could use the SUMIF function for each column of values:

Please Login or Register  to view this content.

[HIT1K]

I wanted to know how to have the 2 of the 3 rows deleted but the information from row 2 and 3 (the deleted ones) must be transferred into row 1 which has 0 values. Is there a way to do that for not just one example but a worksheet which has like 100 entries similar to that. and the sum-if function that you presented doesn't merge cells or remove 0 values or collaborate the 3 rows.