This is how data is available by months and transcation type

Iam trying to extract some financial data which is available by periods (by months) and transaction type (Rev,GM,SGA,OM) and the user can filter by month or select mutilple periods and data needs to be summarised by transaction type which is already set.The only dynamic part is the period which the user can select .I have already set data validation field with multilple filter options for the period .Which excel formula can i use for the financial data to be extracted by period.I have a tried IF formula but the period combinations are huge and excel formula length is crazy.Is there any simplified way of extracting this information??

​This is how data is available by months and transcation typeIam trying to extract some financial data which is available by periods (by months) and transaction type (Rev,GM,SGA,OM) and the user can filter by month or select mutilple periods and data needs to be summarised by transaction type which is already set.The only dynamic part is the period which the user can select .I have already set data validation field with multilple filter options for the period .Which excel formula can i use for the financial data to be extracted by period.I have a tried IF formula but the period combinations are huge and excel formula length is crazy.Is there any simplified way of extracting this information??  Read More

​