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!

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!