Forum Discussion
Solved
Using Filters to Auto-Update Complex Formulas
Hi, This is my first post here. Hoping someone here may be able to assist me. I have the below spreadsheet. There is currently 500 rows of data. At the Top is a Summary Grid with formulas summariz...
It is
=COUNTIFS( A$16:A$4202,"*8*", Table[IsFiltered], 1 )or
=COUNTIFS( A$16:A$4202,"*8*", Z$16:Z$4202, 1 )
Hi Sergei, thank you for responding to my inquiry. Per your suggestion I created a titled "IsFiltered" in Column Z. I attempted to modify the numerator portion of your suggestion, but the "Table[IsFiltered]" is being highlighted by Excel as not working.
=COUNTIFS(COUNTIF(A$16:A$4202,"*8*"), Table[IsFiltered], 1 )
I attempted to have it reference the data in the column to the below, but now Excel is telling I have too few arguments.
=COUNTIFS(COUNTIF(A$16:A$4202,"*8*"), Z$16:Z$4202, 1 )
How do I correct this?
It is
=COUNTIFS( A$16:A$4202,"*8*", Table[IsFiltered], 1 )or
=COUNTIFS( A$16:A$4202,"*8*", Z$16:Z$4202, 1 )Sergei, thank you so much for the clarification. i was able to leverage your second option for my Excel spreadsheet and so far everything is looking good!