I have a sheet with data, I want to count text cells based on other cell's value. For example
A B C
name1 yes Pay
name2 no pay
Total = 2
I want to count cell A when Cell C is empty. I means only count Cell A text values when there is nothing entered in cell C.
I tried this formula
=count(C:C, "", A:A, "<> ") but it counts empty rows of Cell A also.