Forum Discussion
SUMIF and XLOOKUP not working
I have two workbooks (attached). I am trying to retrieve values from one workbook, depending upon an expense category, into the second workbook. (This first workbook [Sample Tolls] has incorrect va...
SUMIF() operates on rows and not on columns.
You don't need to copy the XLOOKUP() down. Because you use multiple criteria cells the formula spills. But the formula is looking for a category in a date column. Not much matching there.
So, I propose a different data structure. Rows without data are omitted.