I have created a validation list. The list has only 2 items.
(1) Closed (2) Open
I want to count the number of opens and closed items. I want the count to be listed up at the top of the sheet in a different column than the validation list is located. If it is blank then it would not be included in the count.
Thanks for your help.
Bookmarks