In your SUMIF formula, the double quotes around the text Yes are not correct double quotes (no idea what they are). Try retyping them ( I don't get the same cocde for your quotes (138) as for mine (34)). It worked for me after that.