Forum Discussion
Selecting Data Based on Multiple Criteria
I need an Excel Formula Wizard to help me with data selection. Following is an example of my data: It is a list of leads that have been received through two different marketing channels (ECO Portal ...
Thank you for working through this for me. I plugged in the original formula you sent me, and I got a #NAME? error. I'm sure it is something on my end, and I think the screen shot you attached will help me. I'm going to keep working it. I haven't had time to open a personal Google Drive account to try to upload a file. I'm sure that would help everybody who has responded. As mentioned, I'll keep working on it and post again when I get closer. Thank you!
=iferror(LET(h,FILTER(A2:R27940,(E2:E27940="Eco Portals")*(I2:I27940="won")*(D2:D27940="Trident of the Sea")*(H2:H27940-F2:F27940<=180)),PIVOTBY(TAKE(h,,3),,TAKE(h,,-1),SUM,,0)),"No Matching Data")
I made some assumptions, but try this.