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.

OliverScheurich

Gold Contributor

Feb 07, 2022

=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.
  - eliaskjohn
    Copper Contributor
    Feb 10, 2022
    OliverScheurich Thank you so much.
    one more query. while copying the formula to another cells, following error is displayed. we can't even save the file without deleting the copied formula.