Subtotal for consecutive rows with conditions

Hi all,

I am having the issue as follow (please see the attached file, I cannot post the table here for unknown reason).

For the value in column "amount", in case the "interest_payment" is "Yes" and the above cell is also "Yes", it will equal the "accrued interest rate"

Otherwise, it will equal the sum up of rows with "interest_payment" is "No". Is there anyway to make the workflow dynamic since the rows with consecutive "No" can vary?

Thank you so much!

Regards,

Source data.xlsx

Best Practices

Accepted answers

atcodedog05

Hi @Antung213

Here is a workflow for the task. I have built for both the cases.

Output: Calculation value is in output column

Please check and let me know.

Hope this helps 🙂

Interest.yxmd

All comments

atcodedog05

Hi @Antung213

In the below statement

Otherwise, it will equal the sum up of rows with "interest_payment" is "No"

Is it all thats all above or only just above it.

No 1

Yes 1

No 1

Yes 1

Is it all above 3 or

just above before the previous yes 2

Can you please confirm.

atcodedog05

Hi @Antung213

Here is a workflow for the task. I have built for both the cases.

Output: Calculation value is in output column

Please check and let me know.

Hope this helps 🙂

Interest.yxmd

Antung213

It is the 2nd case. Thank you so much! It works for me.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335