SOLVED

# XLOOKUP + SUM

Occasional Contributor

# 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 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

# Re: XLOOKUP + SUM

@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.

# Re: XLOOKUP + SUM

@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 (Occasional Contributor)
Solution

# Re: XLOOKUP + SUM

That is

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

# Re: XLOOKUP + SUM

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

# Re: XLOOKUP + SUM

@geraldvassallo , you are welcome