Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Taaly all based on multiple criteria
I keep getting 0 but I know for sure there are 12 people who meet the
criteria. "Teethless mama" wrote: =SUMPRODUCT(--(J2:J100="neg"),--(L2:L100="neg"),--(C2:C100="False")) "Andi" wrote: I am tyring to count the number of individuals who match certain criteria stored in three different columns. I need to count how many people who Tested "neg" for Marker1 (column J), "neg" for marker3(Column L) and "False" for other history (Column 3). I thried using Count(IF(array1), IF(array2)..... but it didn't work for me. I'm obviously doing something wrong! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Taaly all based on multiple criteria
Possibly
=SUMPRODUCT(--(J2:J100="neg"),--(L2:L100="neg"),--(C2:C100=False)) Assuming that the values in Column C are not text but rather are Boolean TRUE and FALSE... Here is a link to sumproduct which will give you some insight into how it works...(bookmark this one) http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Andi" wrote: I keep getting 0 but I know for sure there are 12 people who meet the criteria. "Teethless mama" wrote: =SUMPRODUCT(--(J2:J100="neg"),--(L2:L100="neg"),--(C2:C100="False")) "Andi" wrote: I am tyring to count the number of individuals who match certain criteria stored in three different columns. I need to count how many people who Tested "neg" for Marker1 (column J), "neg" for marker3(Column L) and "False" for other history (Column 3). I thried using Count(IF(array1), IF(array2)..... but it didn't work for me. I'm obviously doing something wrong! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Mode for multiple arrays based on criteria in another | Excel Worksheet Functions | |||
Count unique values based on multiple criteria | Excel Discussion (Misc queries) | |||
Counting and Suming based on multiple criteria | Excel Worksheet Functions | |||
Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |