Notifications
Clear all
Topic starter
Hi,
I have a monthly ledger with description, category and amount with multiple entries per day. I want to select a category (type it on another sheet) and have the total sum of all the entries for that category returned. Can I do this with XLOOKUP?
Thank you
Posted : 29/06/2021 2:44 am
It sounds like you actually want SUMIFS rather than a lookup (which only finds one value).
Posted : 29/06/2021 5:43 am
