I have sheets relating to various cost centers and each line is the spend for a specific account. Let's call the above table as sheet1 and the summary table below, as sheet2. The summary table is like:
I can't figure out the formula to fill in the cells. I have too many to do everything manually, any help would be greatly appreciated!