Forum Discussion
How to categorize companies in Excel
Dear All, First off; thank you for taking the time to help me. I've been looking for the right fix for my problem but can't wrap my head around it. Solution: formula which categorizes companies, i...
That's more job for Power Query. If with formulas when use SUMIFS(), not lookup functions.
I did not understand/comprehend what you just said. I dont use power query. I want to use excel.
Power Query is part of Excel, this functionality is under Get & Transform tab.
Again, you may use SUMIFS() formulas to return companies spending.
- Oh thank you. I did not know that.