I can't understand. Why do I have an error and you do not? My Custom Function https://i.sstatic.net/b2KNelUr.png My Named Function https://i.sstatic.net/H3kWSp2O.png
Named function based on custom function only works with that range in quotation mark =COUNTCOLOREDSCORE("K157:N157") and this ruin my trying to update a range automatically.
If I try to use your example I get the error: https://i.sstatic.net/ko8dUpb8.png