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
...