I would like to move sum A1:A6 If the B cell is = True and another cell is = 1. I have an attachment that shows the layout. Therefore Total = 76.7 Does that make sense? If so how could i work out the formula?