Finding unique values and getting sum of value google sheets app script

Question

Ok so i have a Google sheet having diffrent multiple columns what I need is mentioned below please help me out into achieving them.

1. Number of total hours for a single project (column "C" is having projects and "D" is having hours spent)
2 . contribution person on a project in hours ( column "B" contains name of person).

Both person and projects columns are having repeated entries like person "A" has worked on project for 10 hours and submitted it in two entries (rows) and person "B" has worked for 6 hours on same project and submitted 2 entries so out put I need is

Project total hours = 10+6 = 16
Person a contribution = 10
Person B contribution = 6

Thanks in advance

Answer 1

I will post thr thank you for your suggestion.
and sorry I forgot to mention I'm trying to do it with Google apps script which based on Javascript so we can it's a question related to programming

Answer 2

Oh, I see. Well, maybe someone here would know. Usually posting your code helps.

Answer 3

I'm not sure this is a programming related question, but I think the google community forum might be a good place to ask.