I want to use COUNTIFS on String named 'PASS' in column C, based on the Availability of values in column A but if the cells have values else not consider for counting it in column C COUNTIFS formula.
In my Example attached workbook, In Sheet1, Column A has 4 Values count, Column C has PASS string 6 values count.
In Sheet 2, I am doing COUNTIFS as follows =COUNTIFS(Sheet1!C2:C7, "PASS"), how to modify this to ignore the blank values of A2:A7 and consider only values that are there.
as of now, I am getting a value as 6. But I am expecting it should be 4.
Thank You,
Bookmarks