how to do a countif with these requirements?

[eeps24]

Hello everyone, I am trying to do a countifs but failing to execute it. I think the > 180 is messing me up.

I have 4 columns..

• team name = the teams name
• severity = how bad is the issue
• findings age = how many days the issue has been opened
• exploitability = how likely is it to be discovered

If you look at my screen shot, I did an example of how I want my data to look like.

Example for cell H9 I am looking for a countif that reads...
"team A" (col a), severity of "high" (col b), findings greater than > 180 days (col c) and are "likely" or "very likely" (col d)

I have also attached my sample excel book. I greatly appreciate everyones help!

Capture.JPG

[eeps24]

edit

I mean "likely" or "very likely" . I originally had &. Technically it cant be both at the same time, its one or the other.

I am getting close, I just need to figure out how to incorporate > 180 days.

So far here is my formula that I am using (unless someone has something easier/better) =SUM(COUNTIFS(A:A,"team a",B:B,"4 - high",D:D,{"likely","v.likely"})). I never though I would have to use SUM, I did some searching/youtube.

[eeps24]

I solved it!

=SUM(COUNTIFS($A:$A,"team a",$B:$B,"4 - high",$C:$C,">44",$D:$D,{"likely","v.likely"}))