Forum Discussion

Copper Contributor

Feb 07, 2022

Solved

summing of vlookup values

Can I have a better option for

Formulas and Functions

OliverScheurich
Feb 09, 2022
eliaskjohn
=SUMPRODUCT((D2:G2=$A$2:$A$7)*$B$2:$B$7)

Maybe with this formula.

8 Replies

OliverScheurich
Gold Contributor
Feb 07, 2022
eliaskjohn
=SUMPRODUCT((I3:L3=Sheet1!C:C)*Sheet1!D:D)

Maybe with this formula as shown in the attached file.
sum of vlookup values.xlsx9 KB
- eliaskjohn
  Copper Contributor
  Feb 09, 2022
  Thank you. But it doesn't seems to be what my requirement is. I have just updated my query. can you please check it again?
  - OliverScheurich
    Gold Contributor
    Feb 09, 2022
    eliaskjohn
    =SUMPRODUCT((D2:G2=$A$2:$A$7)*$B$2:$B$7)
    
    Maybe with this formula.