C
C Kuba
Hi,
I am new to this, and desperately need some help. I am trying to put together a workbook that compares multiple data sets. However, I have two variables that specify what information I need. I have two dropdown boxes. One is to specify the group of departments and the other is the month that I want to look at. The group of departments is a total of subdepartments. For example, there are 4 departments A,B,C,D that roll up to group A2 and three departments F,G,H that roll up to group A3. In my dropdown box, I specify that I want group A2 to be evaluated. When I choose A2, I sumif the 4 departments by account. But, I also want to choose what month's data I want to look at using another dropdown box. This is where I get stuck. How do I write a formula that sums by group by account for a specific month. I have tried separating the formula: in one cell, I have specified the group and account as related to the 1st dropdown box. In another cell, I am trying to sum all of the instances of that unique identifier in a given month. The given month, though, needs to be dynamic so that when I click on my month dropdown box, the information adjusts to that month.
I know it sounds convoluted, but is this even possible in Excel?
Thanks for your help!
C
I am new to this, and desperately need some help. I am trying to put together a workbook that compares multiple data sets. However, I have two variables that specify what information I need. I have two dropdown boxes. One is to specify the group of departments and the other is the month that I want to look at. The group of departments is a total of subdepartments. For example, there are 4 departments A,B,C,D that roll up to group A2 and three departments F,G,H that roll up to group A3. In my dropdown box, I specify that I want group A2 to be evaluated. When I choose A2, I sumif the 4 departments by account. But, I also want to choose what month's data I want to look at using another dropdown box. This is where I get stuck. How do I write a formula that sums by group by account for a specific month. I have tried separating the formula: in one cell, I have specified the group and account as related to the 1st dropdown box. In another cell, I am trying to sum all of the instances of that unique identifier in a given month. The given month, though, needs to be dynamic so that when I click on my month dropdown box, the information adjusts to that month.
I know it sounds convoluted, but is this even possible in Excel?
Thanks for your help!
C