3 Replies Latest reply: May 17, 2011 8:53 AM by Doug_S
Doug_S Level 1 Level 1 (0 points)

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.


iMac, Mac OS X (10.6.7), Intel Core i7 2.93Ghz / 12GB RAM / 1TB HDD / ATI 5750HD @ 1GB VR