counting cells in a data range that meet 3 specific conditions

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" <bekah7@discussions.microsoft.com> wrote in message
news:2D6A998C-49D1-4B21-A8E8-0180E44E1183@microsoft.com...
>

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" <bekah7@discussions.microsoft.com> wrote in message
> news:2D6A998C-49D1-4B21-A8E8-0180E44E1183@microsoft.com...
> >
>
>
>

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


--

HTH

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


"bekah7" <bekah7@discussions.microsoft.com> wrote in message
news:0F51DC63-5BF4-483E-A629-F912D17AE971@microsoft.com...
> 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" <bekah7@discussions.microsoft.com> wrote in message
> > news:2D6A998C-49D1-4B21-A8E8-0180E44E1183@microsoft.com...
> > >
> >
> >
> >