Notifications
Announcements
Hi all,I have a excel spreadsheet in SharePoint Document,
I want to do sum of Yearly Income column using a flow , and the sum should be displayed below it
@sabeoleonunes
No need for a Flow. This appears to be a table - just add a totals row to the table from the Table tools ribbon
@sabeoleonunes My solution if you want to do it using Power Automate..
My Excel - Need total of Count Column.
My solution -
The Formula in Compose
add(int(variables('Column')),int(variables('dummy')))
After Flow Run -
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @CFernandes ,The flow has run , but the sum is not been seen in the excel file , any solution for that?
You can add a row to table -
Excel Screenshot -
Hi @CFernandes Hope you are good.There was one more approach I was trying
So I have this column salary with values in it , 1st I need to calculate the sum and display the result above those values and then add sum with 10% and then display the result above sum, So basically I need to display 2 results the sum as well as sum + 10%.(I need to display both the results above the data as mentioned in the picture.)Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 398 Super User 2025 Season 2
David_MA 331 Super User 2025 Season 2
Expiscornovus 203 Most Valuable Professional
