This is probbaly extremely easy, but i can't seem to get it to work, so apologies in advance.
I've attached a sample of what my worksheet looks like. I need a formula that looks in column a for the value DEF, and counts how many of DEF are in Open or Closed status in column B. I keep getting the entire count of Open and Closed values.
The attached sample alos has the desired result listed.
Thank you!
Bookmarks