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
Bookmarks