COUNTIF, with an extra "IF"

[austinugonzalez]

I am trying to keep track of tax clients by category. I have a column for "date paid" and "total fees". If column a (date paid) has a date in it, and column b (total fees) has nothing in it, I want to get the tally for not paid yet. So if no a and yes b how would I get a number for that? Thanks.

[#2 · Accepted solution]

@austinugonzalez 

One possible solution is to use the COUNTIFS function, which counts cells across multiple ranges bas....

In your case, you can use the following formula:

=COUNTIFS(A:A,“<>”,B:B,“”)

This will count the number of rows where column A is not blank and column B is blank. 

The “<>” operator means “not equal to” and “” means an empty string

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

That did the trick. Thanks for the help!

[#4]

I am pleased that you have come to a solution that meets your requirements.

I wish you continued success with Excel.