Forum Discussion

bozhkov's avatar
bozhkov
Copper Contributor
Oct 07, 2023
Solved

Array cell reference based on three values

Hi! Please help me find the values based on my example  
excel
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Oct 07, 2023

    bozhkov 

    In G2:

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

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
Oct 07, 2023

bozhkov 

In G2:

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

Fill down.

bozhkov's avatar
bozhkov
Copper Contributor
Oct 07, 2023

HansVogelaar 

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