ExcelBanter - Taaly all based on multiple criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Taaly all based on multiple criteria (https://www.excelbanter.com/excel-discussion-misc-queries/126847-re-taaly-all-based-multiple-criteria.html)

Teethless mama

Taaly all based on multiple criteria

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

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