Sum values from multiple columns when associated checkbox is ticked

Heidi Muller

Hi

I am trying to use the IF formula to sum multiple column values if an associated column checkbox is ticked - basically duplicating the formula below to the other checkbox field and specific columns. It tried the "AND" function - without luck.

Any expert able to assist?

Thank you

Andrée Starå

@Heidi Muller

Happy to help!

Try something like this.

=IF([C2]@row = 1, [Inv. 2]@row) + IF([C1]@row = 1, [Inv. 1]@row)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Heidi Muller

HI Andree

And Voila! Thank you so much - missed that IF. Learn so much on this platform.

Best Regards

Heidi

Heidi Muller

Andrée Starå

Hi @Heidi Muller

I hope you're well and safe!

You'd add each part together with a + between them.

Make sense?

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Heidi Muller

HI Andrée

Thank you for the quick response.

Please see example - I seem to be doing something wrong:

=IF(([C2]@row = 1, [Inv. 2]@row, " ") + [C1]@row = 1, [Inv. 1]@row, " "))

I look forward to hear from you

Thank you

Heidi

Andrée Starå

@Heidi Muller

Happy to help!

Try something like this.

=IF([C2]@row = 1, [Inv. 2]@row) + IF([C1]@row = 1, [Inv. 1]@row)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Heidi Muller

HI Andree

And Voila! Thank you so much - missed that IF. Learn so much on this platform.

Best Regards

Heidi

Heidi Muller

Andrée Starå

@Heidi Muller

Excellent!

You're more than welcome!