Forum Discussion
Lambda for Getting Sums Based on Dynamic Filters
A while back, someone helped me by drafting a Lambda formula that counted the number of rows in a dynamic table based on multiple dynamic filter values. I now have a need to modify it so it calculate...
Why not simple FILTER() then SUM()? Can you attach a sample file and show your desired output so that we can simplify the formula for you if possible.
Sorry for the delayed reply. What complicates this is the Excel workbook works as a dashboard where data is brought in by PowerAutomate. There are a lot of dynamic pieces, which in other dashboards made it really difficult to utilize just the FILTER() function. I could just have a limited understanding of the function, though. Attached is a sample file.