How Does Summarizecolumns Relate To Filtering?

1.	How Does Summarizecolumns Relate To Filtering?
Answer» SUMMARIZECOLUMNS is not susceptible for OUTER (external) FILTERS, in CONTRAST to SUMMARIZE you can add a FILTER (e.g. using FILTER) as a PARAM of SUMMARIZCOLUMNS and it will filter accordingly. It acts as if you've added a filter in a pivot table.

Answer»

SUMMARIZECOLUMNS is not susceptible for OUTER (external) FILTERS, in CONTRAST to SUMMARIZE
you can add a FILTER (e.g. using FILTER) as a PARAM of SUMMARIZCOLUMNS and it will filter accordingly. It acts as if you've added a filter in a pivot table.

Discussion