I'm trying to create a formula that will sum up the values of multiple cells and show that toal in a seperate cell. Then, if certain checkboxes are checked to alter that total accordingly. I've tried using sumif and sumproduct and I've gotten close but no actual success. I'm including an example in the hope that will help.
Test_01.xls
The checkboxes in cells C4, 5, 6 & 7 are linked to those cells so checked=true and unchecked=false. J3 should show a total of cells E3 through I3. If C4 is checked then the total in J3 should increase by 2 & if cells C5-7 are checked the total in J3 should be reduced by 1 for each checked box. In other words if E3 through I3 all contain a value of 1 the total is 5. If C4 is checked the toal becomes 7. If C4 and C5 are both checked the value changes to 6. And if C5 through C7 are all checked and C4 is not the total would then be 2 (5-3=2). And so on...
Any help is appreciated I have been banging away at this for over 24 hours and I just cannot get any nested functions to combine properly to accomplish this.
Bookmarks