Forum Discussion

Copper Contributor

Jul 22, 2020

Solved

XLOOKUP + SUM

Hello good people, I am working on an excel sheet and trying to make an XLOOKUP formula which will add the values for a particular email address (Test sheet attached) - I have tried to incorporat...

Productivity Test.xlsx18 KB

excel

Formulas and Functions

SergeiBaklan
Jul 22, 2020
geraldvassallo

That is

=SUMIFS(Hours!$C:$C,Hours!$B:$B,$A2)
Productivity Test.xlsx20 KB

wsantos

Brass Contributor

Jul 22, 2020

geraldvassallo Use SUMIF instead.

geraldvassallo

Copper Contributor

Jul 22, 2020

wsantos to give you a further idea, in this sheet, mailto:user3@gmail.com should have a value of 2, however, the formula is coming up with a value of 0.

Productivity Test.xlsx18 KB

SergeiBaklan
Diamond Contributor
Jul 22, 2020
geraldvassallo

That is

=SUMIFS(Hours!$C:$C,Hours!$B:$B,$A2)
Productivity Test.xlsx20 KB
- geraldvassallo
  Copper Contributor
  Jul 22, 2020
  SergeiBaklan Thank you for this!! Very helpful!
  - SergeiBaklan
    Diamond Contributor
    Jul 22, 2020
    geraldvassallo , you are welcome