Solved Sum of several Columns

pinarello

Member
Joined
Jun 21, 2019
Messages
217
Reaction score
4
Points
18
Location
Germany
Excel Version(s)
Office 365
How can I sum the columns whose names are contained in a list in a new column in a table?
 
Assuming the column names are in a list called ColsToSum, you could use something like this for your calculated column formula:

Code:
=List.Sum(Record.ToList(Record.SelectFields(_, ColsToSum)))
 
Thank you very much, this solution fits perfectly !!! I had previously googled but unfortunately found nothing and my own attempts to make it dynamic were all unsuccessful.
 
Back
Top