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
name7 no
name1 yes
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.
Best Answer
Multiple conditions can be specified with
countifs
. For example,says to count a row only if the entry in A column is nonempty and the entry in C column is empty.