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.

  • SUM(MAP(A:A))
  • SUM(B:B)
  • SUM(MAP(B:B))
  • SUM(A:A)
  • SUM(ARRAY(JOIN(MAP(B:B)))
  • JOIN(A:A)