How do I count cells with specific value?
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"))}
|