Hi all
Good day to everyone

I have a excel sheet
Column 1 is Department
Column 2 is weightage
Column 3 is rating of project
Column 4 is filled with either 65% or 35%

I want to sum product of column 2 and 3 based on conditions of column 1 and 2

Can someone share the logic how I can derive this

Simply use sumif, and / or

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%

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.

Thank you Alan & Rover

I have searched on google and found out the formula

=sumproduct(--(Range1,criteria1),--(Range2,criteria2),Range3,Range4)

In this case Range3 & 4 are column 2&3

On 7/17/2019 9:46 AM, TIMOTHY wrote:
Thank you Alan & Rover

I have searched on google and found out the formula

=sumproduct(--(Range1,criteria1),--(Range2,criteria2),Range3,Range4)

=sumproduct(num(Range1,criteria1),num(Range2,crite ria2),Range3,Range4)

I don't know who started this idiom of a double-negation operator
instead...but it's a least confusing to read if nothing else and seems
less efficient besides.

--