Hi ‌

Once you have the collection from Query action, create a For Each loop. Create a variable called varSum of type number. 

Inside loop (for each number in the collection), Add Math function. It would look like this: 

Workflow variable varSum + num (from collection) , save in varSum.

When the loop finishes you will have the sum of all numbers. Hope that helps.

Reference to similar question. 

perform math operation on collection 

Were you able to resolve the issue?

Hi Kapil,

Thank you for your response. I was able to resolve this.

Hi, I have a list with a category column. I need to add values of few column in the list as per category. I don't think using foreach is a good idea as there are 8 to 10 categories, Is there any way I can add all the items in a collections ?

Hi Sunil

I have a similar situation. Were you able to resolve your issue?

Thanks Ren