This is a little confusing, so I've included a demo spreadsheet as a reference.
I'm hoping in Cells I18, J18, and K18 that I can have a selective sum. I'm hoping that I can click a checkbox, and have those regions be summed in the row noted "Dept Responsibility." For example, if I I just had the checkbox by Region 10 checked, I19 would have "$31,708.00", J19 would have "$ - ", and K19 would have "$67,574.00"
Do I need to have a macro do that? Or is there a formula that can do this?
Thanks for your help!
Bookmarks