Morning,
I have a list of monetary values that are associated to reference numbers. What formula can I use in order to sum up the monetary values of the reference numbers if they are the same reference numbers.
For example
Ref: #123 Value: £100
#123 £200
#124...