How to use formulas to pull dynamic numbers?

**djbcktt** · 06-16-2015, 01:09 PM

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!!!Excel Help.xlsx

**oeldere** · 06-16-2015, 02:44 PM

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

http://www.mrexcel.com/forum/excel-q...ed-skills.html

**djbcktt** · 06-16-2015, 02:59 PM

Sorry! It won't happen again! Still need help on this though.

**Glenn Kennedy** · 06-16-2015, 03:26 PM

I looked at htis earlier and gave up - I don't see any way of doing this (within my capability) as, using the current data layout, there's no apparent way of telling where the desired Qs data start. If you had another coumn in there with the quarter number, then maybe...

**djbcktt** · 06-16-2015, 03:31 PM

Thank you for the response, Glenn! So, it might be able to be done if I added a quarter column within each of the 3 tabs? I am just SOOOO familiar Index & Match (assuming that's how it would work) that I really am not sure.

**Glenn Kennedy** · 06-17-2015, 02:59 AM

It can be done... see yellow coloured cellls in inputs. Will there be MANY sheets or just a couple? If many, let me know as there's an alternative which might be worth trying if the sheet number creeps up. I stuck Q1 Q2, etc, in an otherwise empty row. You can hide it, if it offends you!!

There are probably very complicated forumlae that would work without that column, but you may (and I would ...) be unable to maintain them!!