Array cell reference based on three values

[bozhkov]

Hi! Please help me find the values based on my example

[#2 · Accepted solution]

@bozhkov 

In G2:

=SUMPRODUCT(($A$2:$A$10&" "&$B$2:$B$10&" "&$C$2:$C$10=F2)*$D$2:$D$10)

Fill down.

[#3]

@Hans Vogelaar 

Thank you very much for your help, you answered my question completely. But as it turned out, this was not enough to solve my task.
Is there a way to fill the formula dynamically since the range of unique values being looked up may change?

--

P.S.

СУММПРОИЗВ = SUMPRODUCT

ЕСЛИ = IF

[#4]

@bozhkov 

See Dynamically filling formulas in an array 

[#5]

@bozhkov 

To play with variants