Forum Discussion

Copper Contributor

Apr 30, 2019

Solved

Countif/Sumif - 2 Criteria

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.

Excel-wip.xls51 KB

Formulas and Functions

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

4 Replies

Twifoo
Silver Contributor
May 01, 2019
Try modifying your formula to this:
=COUNTIFS($C:$C,G$2,
$D:$D,$E3)
- AVP68
  Copper Contributor
  May 01, 2019
  Twifoo
  I did try the modified formula but the answer is still incorrect. The result is 0.
  - AVP68
    Copper Contributor
    May 01, 2019
    @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.