Forum Discussion
gascandolara
Jul 09, 2021Copper Contributor
Sum results using XLOOKUP
Hi,
I recently learned how to use the XLOOKUP (PROCX in portuguese) in my Excel 365. I made a sheet with my monthly expenses, sorting them by categories. In this sheet, I need to put the totals for each category, and I know that it is possible to do using VLOOKUP with SUM, but I don't know how to add up the results using XLOOKUP, help me please.
(translated from portuguese)
- You should take a look to SUMIF, I think this function should do what you need.
1 Reply
- German_ChrisIron ContributorYou should take a look to SUMIF, I think this function should do what you need.