Lets say I have the following spreadsheet:
ColA ColB
1 pass
1 fail
1 pass
2 pass
1 pass
3 fail
2 pass
In another cell I want to count how many "1" in column A were "pass". I tried to write a count if statement, but it did not work. Here's what I tried: =((COUNTIF(A:A,"1"))*AND((COUNTIF(B:B,"pass")))). This only returns the number of 1s in collumn A.
Can anyone help with single formula?
Thanks,
Jim
ColA ColB
1 pass
1 fail
1 pass
2 pass
1 pass
3 fail
2 pass
In another cell I want to count how many "1" in column A were "pass". I tried to write a count if statement, but it did not work. Here's what I tried: =((COUNTIF(A:A,"1"))*AND((COUNTIF(B:B,"pass")))). This only returns the number of 1s in collumn A.
Can anyone help with single formula?
Thanks,
Jim