Hi All,
Is it possible to count cells in a row with multiple criteria, however the criteria is based on the cell values in the same row AND a single cell value for each column?
The attached spreadsheet hopefully shows what I need. In summary, row 2 identifies whether the column should be included in the count and if "Yes", then for each row count the cells in the same row where the cell value = "Fail". To assist, I've manually input the expected results in column I and highlighted the cells green that should be counted.
The data sets can have upto a hundred columns and a couple hundred thousand rows, which may impact the formula to be used due to prerformance.
Can anybody help?
Thanks in advance
Tooley
Bookmarks