I want a formula that will look across the range below and tell me how many cells have a 1 in Col B but DO NOT have any text in Col A if Col B is 1. In the Data Range below, the formula result would be 1. I thought about something like this: COUNTIF(A2:B13,"AND(ISBLANK(A2:A13),A2:A13=1)") but this does not work however I think it conveys what I want.
Any ideas?
Data Range
Any ideas?
Data Range
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Col A | Col B | ||
2 | test1 | 1 | ||
3 | 1 | |||
4 | test1 | 1 | ||
5 | 2 | |||
6 | test3 | 2 | ||
7 | 3 | |||
8 | test4 | 3 | ||
9 | 3 | |||
10 | 4 | |||
11 | test5 | 4 | ||
12 | 4 | |||
13 | test6 | 4 | ||
Sheet1 |