Ok, so I have the current formula =COUNTIFS(Data!G2:G282,'Defect Aging'!$C$25,Data!D2:D282,">30").
This is checking for Defects that Severity 1 defects that are over 30 days old. I now want to eliminate and defects that have been released. The release date column in column M in the "Data" tab.
Basically, I want a count of all Severity 1 defects that are over 30 days old but subtract any that have a date in the M column. How do I do this?
Thanks so much!
Bookmarks