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)
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Leave a Comment

Share via
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Send this to a friend