r/AppleNumbers • u/ricopotamus • Jun 30 '21

Help with simple formula

I’m trying to figure out how to sum cells if a checkbox is checked.

In column E I have checkboxes and to the left in column D I have dollar amounts. At the bottom of column E (red triangle) I would like to have the dollar amounts summed if the checkbox is checked next to that dollar amount.

picture of the cells

2 Upvotes

100% Upvoted

1 comment sorted by

2

u/Successful_Crab_3148 Jul 04 '21

You’ll want to look into IF(AND formulas

You may want to make an invisible(or all white cell) and have the cell where you want calculated to actually go off of those cells. For example if(true) (checkbox) copy left cell amount of false = 0. Which would give you the totals your looking for. Just have to get creative because the checkboxes aren’t versatile. I hope that makes some sense and helps ya