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 be HUGE! See attached

[v-yalanwu-msft]

Hi, @kjsmercier ;

Hello, sorry not seeing the attachment provided, can you check if you forgot to upload?
Secondly, since your tables are all checkboxes and do not have numbers, can you say what is the logic of summation?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.