Sumif formula based on Radio button selection

SELECTED ANSWER

replied on May 19, 2022

Will this work?

Set a numerical value for each of the radio button options:

Then your formula in the table just needs to check if the radio button is equal to the specific row in the table, if it is, return the processing fee, otherwise return zero - then add that to the other value: =IF(Select_Processing_Fee=ROW(),Processing_Fee,0)+Deduction_Amount

It seems to work in a quick mock-up:

2 0

View 1 previous reply

replied on May 24, 2022

Fantastic! Have a great day!

0 0

replied on June 2, 2022

Hi Matthew,

Just following up on this. The formula worked great for the main deduction amount. What I would like to do is add $25 to the current deduction amount.

My current Deduction Amount (Grand Total) is $600 and I need to pay it back in 3 payments of 200 each.

If I select Second Pay Period it adds $25 to that $200 value.

With the formula provided it adds $25 to the grand total deduction amount and if I try changing these values it will reset to 600 instead of 200.

Any advice would be appreciated.

0 0

replied on June 2, 2022

Is the Deduction_Amount field calculating from the values in the table? If so, then I think we have some circular references - the values in the table are calculating from the Deduction_Amount field and the Deduction_Amount field is calculating from the values in the table. That's going to result in some weird behavior.

The formula I tested and shared were assuming that both the Processing_Fee field and the Deduction_Amount field were either entered manually or calculated external to the table, but if either of those is calculating off of the table itself, this will result in circular calcualtions.

0 0

Question

Question

Sumif formula based on Radio button selection

Answer

Replies

Sign in to reply to this post.