Formula required please

I have tried an If Statement, but my expertise isn't great.

What i am trying to do on a simple table is to get the summary cell to provide the right code, if a Y is present under one of the headings, but also to add any others with a Y, as in the Example.

If there is a N or N/A then that code is not to be shown.

Any help would be appreciated.

thanks.