Hey there,
I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the Inputs tab, I want C23 to sum the Number of Performance Period Episode Cases (2014Q2) of Major joint replacement of the lower extremity for the Current Quarter (in this case, Q2 2014) from both EI #1 Inputs and EI #2 Inputs. Then, when I update to Q3 2014, it will do the same function except for Q3 2014, and the rows will have changed. Is that possible? Thank you!!!
https://www.dropbox.com/s/hjx8vbnpgq7xndo/Excel%20Help.xlsx?dl=0
I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the Inputs tab, I want C23 to sum the Number of Performance Period Episode Cases (2014Q2) of Major joint replacement of the lower extremity for the Current Quarter (in this case, Q2 2014) from both EI #1 Inputs and EI #2 Inputs. Then, when I update to Q3 2014, it will do the same function except for Q3 2014, and the rows will have changed. Is that possible? Thank you!!!
https://www.dropbox.com/s/hjx8vbnpgq7xndo/Excel%20Help.xlsx?dl=0
