So, I have a workbook that contains several spreadsheets in it. There is an individual sheet for each of about 13 individual accounts. All the information input into each individual sheet then links to a shared sheet. On the individual sheets, I have created drop down menus that select the month an expense is incurred and the type of expense(category). The If/Then formula I received on this forum once before is as follows: =SUMIFS('AUSTRALIA 60-3-0001'!$D$4:$D$1048576,'AUSTRALIA 60-3-0001'!$B$4:$B$1048576,C$5,'AUSTRALIA 60-3-0001'!$C$4:$C$1048576,$B6)
Australia 60-3-0001 refers the the individual account sheet being reference into the shared sheet. The formula works fine, however there is an expense category named Overhead. In the individual account sheet I have set up where a 22% overhead expense is generated for each expense entered, yet it is not one of the categories selected in the drop down menu. There is a corresponding category field in the shared sheet that I am trying to have populated with a running total of overhead expenses for each selected month. How do I create a formula to do this?
I have attached the actual workbook here.AP accounts expense worksheet.xlsx
Bookmarks