Forum Discussion

swans222's avatar
swans222
Copper Contributor
Jan 25, 2021

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

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! 

 

 

Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 26, 2021

    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.

Resources