Question about Calculation related to 4 different check boxes!!!
Pls see the screenshot below:
Pls note that the grand total & the grand amount are sum of amount#1~#4 and total#1~#4
Here is my question, I only want to sum up the grand amount and grand total when YES is checked
In this case, what formula should I put?