I tried using it for other columns by changing the range but it seems doesn't work? May i know why is that so?

Many thanks!