How to calculate sum and write for each specific data

[Mathkar_kunal]

hello ,
i need expected output like below in excel column

value for expected output is calculated using column hours for column project.
if you see in project column there are total 3 projects as below and calculation -
DC0556 - coming 7 times - 7* 8 Hours = 56
DC0558 - coming 2 times - 2* 8 Hours = 16
DC0559 - coming 1 times - 1* 8 Hours = 8

how can i achieve this and this data may vary means for now 11 rows are there it may extend to 40/50 like that and project count as well per user.

please help me on same

[ashokkarale]

@Mathkar_kunal,

Just use SUMIF excel formula here.

SUMIF function - Microsoft Support

[Mathkar_kunal]

ok but there are 3 different project and to calculate for 3 individually and to write in I column, how can i achieve that or what formula should i apply here?
i tried to apply below one, but it shows value 0

it suppose to show 16

[Mathkar_kunal]

OK UNDERSTOOD
=SUMIF(S2:S11,“DC0558”,C2:C11)

THIS IS THE RIGHT FORMULA