Countif/Sumif - 2 Criteria

[AVP68]

Hello,

I have a dataset and worked out couple of formulas of what I need and stumbled on my last formula where I am trying to do a count after double match. Please see attached sample file and the info in text box clearly outlines what I am trying to accomplish.

Thanks.

Jay.

[#2 · Accepted solution]

Try modifying your formula to this:
=COUNTIFS($C:$C,G$2,
$D:$D,$E3)

[#3]

@Twifoo 

I did try the modified formula but the answer is still incorrect. The result is 0.

[#4]

@Twifoo 

It's all good now, when I copied and pasted one of the cell references got changed to the wrong cell.

Thanks! Works great.

[#5]

You’re welcome.