Forum Discussion
COUNTIF, with an extra "IF"
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.
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.
I know I don't know anything (Socrates)
3 Replies
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.
I know I don't know anything (Socrates)
- That did the trick. Thanks for the help!
- I am pleased that you have come to a solution that meets your requirements.
I wish you continued success with Excel.
