5 Replies Latest reply on Feb 5, 2014 12:37 PM by erolst

    Grouping and summing a list

    liltbrockie

      Hi there...! Calling all Custom Function wizards I need your help!!

       

      I am trying to make a custom function that can take a list of values like so:

       

      Bob|5

      Mary|3

      Anne|3

      Bob|5

      Frank|1

      Bob|5

      Anne|2

       

       

      And turn it in to a group summed list like this:

       

      Bob|15

      Mary|3

      Anne|5

      Frank|1