Forum Discussion
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
geraldvassallo Use SUMIF instead.
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.
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.
