Calculating Totals from dynamic table

Hi Everyone,

I have looked though this forum but i think i am facing a unique issue that i need your help with.

In the attached file, there are two tabs, data and data summary. I want the data summary tab to pick up the yearly totals from the "Data" tab.

However, there are two issues:

1- the table in the Data tab varies from month to month (Columns and rows move, and are deleted/ added)
2- The data i need is dependent on 3 variables: The Org, Currency and the total.

For Example of Cell C9 of the data tab, i need excel to look at the table (which changes each month), narrow down org. 2100 and USD and then return the total for 2018.

I would really appreciate your help with this! Thank you in advance!!

Sohshak

Sorry, i forgot to add. Sometimes there are multiple occurrences of org and Currency whereas sometimes its one org and one currency.

In this case, its possible for org. wth no listed currencies to equal zero through an iferror formula so that the data summary tab picks up the information it needs and zero's out the information that is not available?

Thanks,

sohshak

Okay, find attached a more representative example spreadsheet.

I have manually filled out the data summary tab for 2018 for the first two companies. I want to automate this process so that excel can recognize that Org. 2100 with currency of TLR has a 2018 total of 200.

Please share your thoughts.