Jul 22 2020 08:04 AM
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
Jul 22 2020 09:04 AM
@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.
Jul 22 2020 09:32 AM
@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.
Jul 22 2020 11:04 AM
SolutionJul 22 2020 11:04 AM
Solution