Forum Discussion
ajl_ahmed
Oct 19, 2024Iron Contributor
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
For example:
=LET(names, C9:C12, totals, BYROW(D9:F12, SUM), combined, HSTACK(names, totals), FILTER(combined, totals>0, ""))