Sum results using XLOOKUP

[gascandolara]

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)

[#2 · Accepted solution]

You should take a look to SUMIF, I think this function should do what you need.