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...
It is quite possible but ...
1. You must perform the summation before converting multiple measures to text
2. You cannot use OR to evaluate an array of Boolean operations because it combines the entire array
(plus '+' provides a workaround)
3. I do not recommend adding Kg and Lt unless you know the density of the ingredients.
Are you able to use the LET function to make sense of your calculation?