counting cells in a data range that meet 3 specific conditions

E

Earl Kiosterud

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

bekah7

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??
 
B

Bob Phillips

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


--

HTH

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