Forum Discussion
Solved
How to sum an array, after applying a few conditions to it? It's complicated, I'm attaching a file.
I'm attaching a file. It's self explanatory. I wanna convert the array to be summed base on a different array and then do the final summation. Is it possible to achieve this without adding a he...
Glad to have at least contributed some ideas.
The attached file uses index to identify the columns for the ingredients, quantity and units, but the main difference is that it encloses the entire formula within a Lambda function which it then names as SUMMARY. That makes SUMMARY(1) the summary data for recipe 1 etc.
This is no help whatsoever to you right now, unless you happen to be on the 365 insiders beta channel, but it should work some time in the future when the Lambda functionality is rolled out.
Yes, I'm too waiting for lambda to be rolled out on regular Microsoft 365.