In column B I have a validation list with about 20 clients listed.
In column J I have a validation list of Closed or Open.
I want to create a list that tallies for each client the number of closed and open items I have.
I entered:
=COUNTIF(B4,"Client Name")=COUNTIF(J4,"open"=count)
I receive a FALSE answer if it is closed or a TRUE answer if it is OPEN.
What am I doing wrong?
Thank you in advance, as I have received such good answers today. I really appreciate it.
Bookmarks