Forum Discussion

eliaskjohn's avatar
eliaskjohn
Copper Contributor
Feb 07, 2022
Solved

summing of vlookup values

Can I have a better option for  
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 09, 2022

    eliaskjohn 

    =SUMPRODUCT((D2:G2=$A$2:$A$7)*$B$2:$B$7)

     

    Maybe with this formula.

eliaskjohn's avatar
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's avatar
    OliverScheurich
    Gold Contributor
    Feb 09, 2022

    eliaskjohn 

    =SUMPRODUCT((D2:G2=$A$2:$A$7)*$B$2:$B$7)

     

    Maybe with this formula.

    • eliaskjohn's avatar
      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.

      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        Feb 12, 2022

        eliaskjohn 

        That's difficult to say without seeing the file or the formula in column H. Can you communicate the formula you entered in cell H8? Probably too many calculations are required to return the result of the formula.