Total values in one column based on duplicate copies in another column

I'm wanting to use a formula (rather than pivot table) that will total values of repeated text as per the green column in my sample spreadsheet. I think it would work with a IF or SUMPRODUCT Formula but not sure excatly how to set the formula out to make it work like I show in the green column.

I originally tried

=SUMPRODUCT(($B$2:$B$26=B2)*$C$2:$C$26)


But this repeats the total on each row rather than just the total on the final row of the repeated text (as shown in the sample)

Any suggestions would be welcomed. I'm sure it's pretty straight forward when you know how lol

**SORRY WRONG FILE ATTACHED - PLEASE SEE POST #3 FOR CORRECT SPREADSHEET**

I see no green column in your file?

Have you tried using SUMIFS()?

Try in E2 then drag down:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

@ grim, that happens to all of us from time to time, no big deal, just happy you go the answer you needed