If you used the COUNT formula you must hold the CTRL and SHIFT keys down after you type or paste in the formula and then hit ENTER...

otherwise, use the SUMPRODUCT() version and just hit ENTER.