Try this

=COUNTIF(Data!N2:Data!N2,"Y")+COUNTIF(Data!W2:Data!W2,"Y")+COUNTIF(Data!AA2:Data!AA2,"Y")+..........and so on

maybe this is what u want?

Azumi