How to get summation of Rows in Excel File through PAD

(0) Share

Report

Posted on by SA_VOH

210

I have 2 queries:-

1. I have an Excel sheet which carries data - date wise i.e. 01-30 June-22 (all dates present in the calendar month).

I would like to insert a single blank row after dates 01-08 June-22, then 09-15 June-22, then 16-23 June-22 and then 24-30 June-22.

Inserting rows not a issue.

After that, i want PAD to calculate summation of data b/w 01-08 June-22 and place in the blank row (which exists b/w 01-08 June-22 and 09-15 June-22) and so on.

2. Is there any way through i can work on a Loop for a folder, containing Excel files. I want the loop to open all the Excel files one by one which are placed in a folder, perform some common function and close the files.

Any help?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@SA_VOH You can refer these videos to begin with:

https://www.youtube.com/watch?v=bWUdUrCvfiY
https://www.youtube.com/watch?v=i4Z-dRtqkhU
https://www.youtube.com/watch?v=N2rbNN--TTI

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

@SA_VOH

For 1. You mentioned that inserting a row is not an issue. So while doing so just maintain two variables for Start and End row. Meaning: Start row is the row FROM where you want to start the sum and end is the row TILL where you want to apply the sum formula.

Once they are available you will be able to add the formula as below

=SUM(A%StartRow%:A%EndRow%)

For 2. Yes, you can.

Was this reply helpful? Yes No
SA_VOH 210 on at

Like (0)

Report

HI VJR,
Your solution is great but i think i was unable to tell my problem properly. Apologies for same.
I have my Excel data like the image shown below:-

For inserting row, i entered the following step in PAD.

I was successful, by entering the formula I.E. Sum (C3:C10), i was able to get summation, but i want the PAD to move to next cell D11 & calculate sum (D3:D10) and so on or E column also.

How can i dynamically move my Excel column, as columns are represented by Text i.e. A, B or C and not numbers and as such i can't increment them with +1.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

You can move 1 cell offset to the right by using "Activate cell in Excel worksheet".

And then use "Get active cell on Excel worksheet" to get its column number.

Was this reply helpful? Yes No
SA_VOH 210 on at

Like (0)

Report

Hi VJR,
ok.
But i need a Loop condition so that i can calculate the summations for each of the columns as mentioned above. Which Loop condition will suit here best?
So that my Active cell moves to the right till column E and calculates summation of C3:C10 , then D3:D10 and E3:E10 while moving right each and every time.

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report

Cannot see your full sheet so assuming E is your last column you can use "Get first free column/row from Excel worksheet".

Also "Get column name on Excel worksheet" gives the alphabet name out of the column number.

Was this reply helpful? Yes No