Checkbox Sums

[kjsmercier]

I am new to Power Query and am trying to figure out how to sum on a single value. I am looking to sum $ on a checkbox. Ie: I would like to be able to check boxes in Column I, Row 4, Column, J Row 4 and Column L Row 4 and have it sum up the total cost from the same columns in row 3. I Named a table (See column through R Rows 2 and 3) but cannot seem to get the query to work correctly. Any help would eb HUGE! See attached

 

[kjsmercier]

I am new to Power Query and am trying to figure out how to sum on a single value. I am looking to sum $ on a checkbox. Ie: I would like to be able to check boxes in Column I, Row 4, Column, J Row 4 and Column L Row 4 and have it sum up the total cost from the same columns in row 3. I Named a table (See column through R Rows 2 and 3) but cannot seem to get the query to work correctly. Any help would eb HUGE! See attached

 

[jdellasala]

Power Query is not the solution here. Formulas can do this. Try SUMIFS.

 

[kjsmercier]

Power Query is not the solution here. Formulas can do this. Try SUMIFS.

Yes, I know I can do it with normal functions. I was just told Power query would be a better way to go but maybe not

 

[jdellasala]

Yes, I know I can do it with normal functions. I was just told Power query would be a better way to go but maybe not

If you need to get rid of the columns with checkboxes and flatten the rest of the data out or MAYBE replace the checkboxes with values depending on whether or not they're checked and then flatten it out, it might be the answer, but as presented, Power Query is NOT the answer.
Presumably the checkboxes have related Cell values of at least TRUE and FALSE, in which case a formula should work fine.