Skip to main content
Typo
Source Link
JohnSUN
  • 896
  • 1
  • 4
  • 9

I don’t know if this option would be easier, but for me the formula

=SUMPRODUCT=SUM(ARRAYFORMULA(IF($E$4:$J$9=$A4,N($E$3:$J$3=B$3),0)))

placed in cell B4 and then stretched over the entire range B4:D9 gave the same result as that of our respected colleagues Blind Spots and doubleunary

I don’t know if this option would be easier, but for me the formula

=SUMPRODUCT(IF($E$4:$J$9=$A4,$E$3:$J$3=B$3,0))

placed in cell B4 and then stretched over the entire range B4:D9 gave the same result as that of our respected colleagues Blind Spots and doubleunary

I don’t know if this option would be easier, but for me the formula

=SUM(ARRAYFORMULA(IF($E$4:$J$9=$A4,N($E$3:$J$3=B$3),0)))

placed in cell B4 and then stretched over the entire range B4:D9 gave the same result as that of our respected colleagues Blind Spots and doubleunary

Post Undeleted by JohnSUN
Post Deleted by JohnSUN
Source Link
JohnSUN
  • 896
  • 1
  • 4
  • 9

I don’t know if this option would be easier, but for me the formula

=SUMPRODUCT(IF($E$4:$J$9=$A4,$E$3:$J$3=B$3,0))

placed in cell B4 and then stretched over the entire range B4:D9 gave the same result as that of our respected colleagues Blind Spots and doubleunary