See this for more detailed info on SUMPRODUCT:

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Biff
Microsoft Excel MVP


"Guntars" wrote in message
...
Thank you T. Valko. That is what I am looking for, simpler shorter
formula. I
do understand that almost always there is more than one way to accomplish
desired result. The key is, to do that as simple as possible!
Thank you
Guntars


"T. Valko" wrote:

{=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"))}