Hi, I'm trying to plot a chart whereby

Status Type
open defect
closed CR
open CR
closed defect

I need to chart all those defects that are open or closed only not
including CR
I'm using COUNTIF for open and closed.

I hope this makes sense.