Count a select total of one column using two criterias

[Yaya1900]

Hi,

I need a formula to calculate a total number of incidents that are 1) active status and 2) raised by the target users. I have shown a small example in below image. Thank you in advance

Regards,

 

[hrayani]

=COUNTIFS($C$2:$C$27,"Active",$D$2:$D$27,G3)

 

[Yaya1900]

=COUNTIFS($C$2:$C$27,"Active",$D$2:$D$27,G3)

Thank you

 

[hrayani]

Thank you

you are welcome & thanks for the feedback

 

[Yaya1900]

you are welcome & thanks for the feedback

I apologize for my amateur questions. Could you kindly tell me a formula to count active incidents for all 5 names together in one cell?

 

[hrayani]

=COUNTIFS($C$2:$C$27,"Active",$D$2:$D$27,G4,$D$2:$D$27,G5,$D$2:$D$27,G6,$D$2:$D$27,G7,$D$2:$D$27,G8)