On Tuesday, 16 July 2019 04:01:30 UTC+1, TIMOTHY wrote:
Sumif is sum of selected values based on condition

Here I want to multiply column 2 respective weightage and column 3 respective ratings based on department. Some department 65% payment & remaining department 35%

Hi
Isn't it just
=B2*C2*D2
since column D contains the Percentage relevant to the Department.
Column D could be a Lookup to a table of Departments and Percentages.