Hi guys,

I'm using excel 2010 and have run into an issue on one of my spreadsheets. Currently I'm using a countif function to count all letter 'Y's as 1 and I need to add in so I can count another letter as 0.5. Does anyone know what formula I can add it?

The current formula I'm using is =COUNTIF(I16:I33, "*Y*")

Thanks