Dynamically Update CountIf Formula Based On Nested List

**SamuraiSam83** · 01-13-2015, 08:41 PM

Hi. I have a workbook that multiple sheets, each with it's own portfolio. I have a main page that contains the charts that correlate to each portfolio. On the main page, I have a Portfolio dropdown list, which brings up the respective stock symbols that are on each Portfolio page. Currently, I have a CountIf formula that works only when the selected Portfolio is List 1. I would have to change the CountIf formula if I change the Portfolio to List 2 or List 3. I would like the CountIf to automatically update to the matching Portfolio selection.

I have included a sample file.

**mikerickson** · 01-13-2015, 08:55 PM

You could do this with INDIRECT

=COUNTIF(INDIRECT(A2&"!A2:A4896"), B2)

**SamuraiSam83** · 01-13-2015, 09:09 PM

Hi,

So, I got the CountIf formula to work, but now the problem I'm having is that the coding in my table is not updating based on my Portfolio selection. I thought about adding the Indirect command to my data in the table, but I don't know where I would insert that code.