Sum results using XLOOKUP

Occasional Visitor



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)

1 Reply
best response confirmed by gascandolara (Occasional Visitor)
You should take a look to SUMIF, I think this function should do what you need.