SOLVED

XLOOKUP + SUM

Copper Contributor

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 incorporate SUM with XLOOKUP formula but it is not calculating the different values but only giving the first one it finds. 

 

Searched online however I couldn't find a proper solution for this. 

 

Would appreciate any help. 

 

Thanks,

Gerald

6 Replies

@geraldvassallo  Use SUMIF instead.

@wsantos Thank you for that :) It seems to be working better now, however, when using it with the main sheet I'm using, the calculations are somewhat wrong and not showing the true value. 

 

Thank you for your assistance. 

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

 

 

best response confirmed by geraldvassallo (Copper Contributor)
Solution

@geraldvassallo 

That is

=SUMIFS(Hours!$C:$C,Hours!$B:$B,$A2)

@Sergei Baklan Thank you for this!! Very helpful! 

@geraldvassallo , you are welcome

1 best response

Accepted Solutions
best response confirmed by geraldvassallo (Copper Contributor)
Solution

@geraldvassallo 

That is

=SUMIFS(Hours!$C:$C,Hours!$B:$B,$A2)

View solution in original post