sum of duplicates

[GordonLS]

Good morning, Column A has duplicates. I need column F to populate with the sum of column C, D, E only once per cus_id.
For instance row 3 and 4 have duplicate cus_id. I need the total of 3 and 4 in Cell F4. F3 needs to be blank

 

[Fluff]

How about

=IF(A2=A3,"",SUMPRODUCT(($A$2:$A$20=A2)*($C$2:$E$20)))

 

[GordonLS]

Perfect. Thank you much.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[GordonLS]

How do we get F to populate as follows. If column A is unique "3.95", but if more than 1 we need the 1st to populate "4.95" and all others with the same code to populate "1.95".

 

[Fluff]

As that is a totally different question, it needs a new thread. Thanks