{=SUMPRODUCT(--(A1:A8="ONE")*(B1:F8="Y"))}

No need to array enter. Just a normal enter will do. Also, no need for the
"--".

=SUMPRODUCT((A1:A8="ONE")*(B1:F8="Y"))

--
Biff
Microsoft Excel MVP


"Guntars" wrote in message
...
Thank you all, for all your suggestions and solutions, I think I am
getting
better at array formulas, this is what I come up with"
{=SUMPRODUCT(--(A1:A8="ONE")*(B1:F8="Y"))}