Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Oct 19, 2024

Filter Function

Hi

I am using google sheet and I need to filter range of cells such that the names with the sum of their related cells should be filtered. The condition of filtering process is any of the related cell contain number value.  see the attached file.

Thanks 

  • ajl_ahmed 

    For example:

    =LET(names, C9:C12, totals, BYROW(D9:F12, SUM), combined, HSTACK(names, totals), FILTER(combined, totals>0, ""))

Resources