Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bekah7
 
Posts: n/a
Default counting cells in a data range that meet 3 specific conditions


  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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



  #3   Report Post  
bekah7
 
Posts: n/a
Default

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




  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
data range props Steve M Excel Discussion (Misc queries) 0 April 11th 05 10:32 AM
data range Steve M Excel Discussion (Misc queries) 0 April 4th 05 11:17 PM
Eliminate empty cells in data range Stephen Excel Discussion (Misc queries) 1 April 2nd 05 04:00 AM
Data range properties baz Excel Discussion (Misc queries) 1 April 1st 05 09:37 AM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"