Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting cells in a data range that meet 3 specific conditions
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
=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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
data range props | Excel Discussion (Misc queries) | |||
data range | Excel Discussion (Misc queries) | |||
Eliminate empty cells in data range | Excel Discussion (Misc queries) | |||
Data range properties | Excel Discussion (Misc queries) |