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.

Advertisement

  • 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.

We respect your privacy and take protecting it seriously

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.

We respect your privacy and take protecting it seriously

Send this to a friend