Forum Discussion

AVP68's avatar
AVP68
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 i...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    May 01, 2019

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

AVP68's avatar
AVP68
Copper Contributor
May 01, 2019

Twifoo 

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

 

 

AVP68's avatar
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.

 

 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 01, 2019
    You’re welcome.

Resources