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.

1 Answer 1


Multiple conditions can be specified with countifs. For example,

=countifs(A:A, "<>", C:C, "")

says to count a row only if the entry in A column is nonempty and the entry in C column is empty.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.