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)

Twifoo's avatar
Twifoo
Silver Contributor
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