Forum Discussion

gascandolara's avatar
gascandolara
Copper Contributor
Jul 09, 2021
Solved

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_Chris's avatar
    German_Chris
    Iron Contributor
    You should take a look to SUMIF, I think this function should do what you need.