Hello John,

you can make a for each loop und test if the value is y or n.

For each vItem in myrng
if vItem = "y" then count = count +1
next vItem