Share via

Is there a way in Microsoft Loop to sum the numbers in columns?

Anonymous
2025-01-03T10:35:28+00:00

Is there a way in Microsoft Loop to sum the numbers in these columns to the bottom row of their respective columns?

Maybe a formula like in Excel.

PS: I've tried to use =sum( formula, but it didn't work.

PS2: A question about Loop. However, I marked Teams because Microsoft Loop is not in the required section below.

Microsoft Teams | Microsoft Teams for business | Tasks | Manage tasks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-03T12:44:03+00:00

    Hi Achllus,

    Thank you for reaching out!

    Yes, you can sum the numbers in columns within Microsoft Loop, but it works a bit differently than in Excel. Here’s how you can do it:

    1. Select the Column Type: Ensure the columns you want to sum are set to the "Number" type.
    2. Use the Drop-Down Menu: At the bottom of each column, there should be a drop-down menu. Click on it and select "Sum" to get the total for that column.

    Unfortunately, more complex formulas like =SUM() from Excel aren't supported directly in Loop. If you need more advanced calculations, you might consider using Excel Online and embedding it within your Loop component by copying and pasting its link. Refer to this link: Can tables inside a Loop component do Formulas? - Microsoft Community

    If you have any further questions, feel free to let me know!

    Best regards,

    Community Moderator | Sophia

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2025-02-11T11:21:20+00:00

    Loops Formula:

    Is it possible to add a label/title to the mini-row that includes the sum, count, and averages of a table within Loops?

    Also, is it possible to create a separate table calculating the total sum of multiple tables within Loops?

    I currently have multiple tables with sums, but would like to use the total from each Number column for scoring purposes. If this option is not currently available, please let me know if there are any other possible ways to calculate and display this.

    Loops Formatting:

    Further, is it possible to merge columns in a Loops table? In which case, maybe multiple tables wouldn't be needed and "headers" could be displayed as a merged column, that way the numbers column could be summed with all data in one single table?

    Was this answer helpful?

    0 comments