Apr 30 2019 03:49 PM
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.
Apr 30 2019 06:42 PM - edited Apr 30 2019 06:47 PM
SolutionTry modifying your formula to this:
=COUNTIFS($C:$C,G$2,
$D:$D,$E3)
Apr 30 2019 07:10 PM
Apr 30 2019 07:27 PM
It's all good now, when I copied and pasted one of the cell references got changed to the wrong cell.
Thanks! Works great.
Apr 30 2019 06:42 PM - edited Apr 30 2019 06:47 PM
SolutionTry modifying your formula to this:
=COUNTIFS($C:$C,G$2,
$D:$D,$E3)