Correction...

=SUM(--(MMULT(--(A1:C10="Y"),TRANSPOSE(COLUMN(A1:C10))*0+1)0))

....confirmed with CONTROL+SHIFT+ENTER.

In article ,
Domenic wrote:

=SUMPRODUCT(--(MMULT(--(A1:C10="Y"),TRANSPOSE(COLUMN(A1:C10))*0+1)0))

...confirmed with CONTROL+SHIFT+ENTER.