Forum Discussion
SUMIFS with vLookup or Indexing?
I have a spreadsheet of data, about 7k lines that I need to cost allocate. I've added a small portion below as an example. What I would like to display with a formula is the total for each cost cente...
Yu may aggregate that with PivotTable. Cost Centres to split manually or with Power Query, when the result is
Follow up - in the above view, cost center 3571 shows a full $0.42 but I want to split it in half (between 3571 and 2616). How do I achieve this?