667 Views 3 Replies Latest reply: May 17, 2011 8:53 AM by Doug_S
Right, so I have a list of upcoming purchases. Each row has a checkbox, a description, a min-price and a max-price (based on estimates I enter manually). In the footer-row I have a sum for the min and max column. However, I'd prefer to only include the sum of items where their corresponding check box is not checked.
So, in other words, when a check box is checked, I want that min and max not to be included in the corresponding sum.
However, I have no idea how to do an if statement that tests to see if a box in the same row is checked. the checkbox is in column A and the sums are in C and D, respectively.