- SUM(MAP(A:A))
- SUM(B:B)
- SUM(MAP(B:B))
- SUM(A:A)
- SUM(ARRAY(JOIN(MAP(B:B)))
- JOIN(A:A)
Which Of The Following Formulas Is The Best Option For SUM’ing A Set Of Values Held In Column A Of Multiple Dynamic Data Source Instances? NOTE: The Possible Values For The Dynamic Property Is In Column B Of A 2nd Data Source.
Which Of The Following Formulas Is The Best Option For SUM’ing A Set Of Values Held In Column A Of Multiple Dynamic Data Source Instances? NOTE: The Possible Values For The Dynamic Property Is In Column B Of A 2nd Data Source.