Excel applies the formula based on the custom VBA code you entered earlier. Excel adds all of the figures in the cells without strikethroughs and ignores the ones that have them.