summing up second column value if the same value in first column!

[adbasanta]

Good day!

I just need some help on how to sum up values if they has the same names..

Ex..

Please Login or Register  to view this content.

the result mus be:

Please Login or Register  to view this content.

thank you!

sample file attached!

[tom1977]

Hi try sumif function look into attachment

[Mallycat]

Sumif is a good option. Another option is to use subtotals. First put a header row over your data, select the data and then click the DATA\SUBTOTALS. You can then expand collapse the totals from the data as required.

[kisho20]

Hi Try this formulae for each names

=SUMIF(C3:C16,"Juan Dela Cerna",D3:D16)

[adbasanta]

Thank you guys..all of your solutions are great..