=SUMPRODUCT(--(A2:A200="tall"),--(B2:B200="dark"),--(C2:C200="handsome"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"bekah7" wrote in message
...
Sorry, need info on creating a formula that will count within a range
based
on three pieces of criteria, i know i have to nest but am way
lost...blonde
:) ex: i have a database full of info on men, and I want to count all the
ones that are tall, dark and handsome, but I can only get it to give me
tall,
or dark, or handsome, not all three...its the best waay i know to explain
my
issue??

"Earl Kiosterud" wrote:

Bekah,

=SUMPRODUCT((boolean1)*(boolean2)*(boolean3))

I'd like to be more specific, but your post was just too long, and I
didn't
read it all.

--
Earl Kiosterud
www.smokeylake.com

"bekah7" wrote in message
...