Filtered Data Utilizing Sum Product for Totals - Need Associated Text Field

[swans222]

Hi All - Running into a roadblock trying to solve the following issue: 

- I have a filtered list of data that I needed to count visible cells with specific text, I was able to do that with a SUMPRODUCT function. 

- Now that I have these totals I need to show a list of text associated with the rows of data that have been counted through the SUMPRODUCT function. 

How can I do this? I've tried a few different things and nothing has worked. Thanks in advance! 

[#2]

@swans222 

You may add helper column with formula as

=AGGREGATE(3,5,[@anyColumn])

which returns 1 for visible columns and zero instead. Use it in SUMPRODUCT()

I used structured reference, will be cell reference if that's not a Table.