79792583

Date: 2025-10-16 21:23:46
Score: 1
Natty:
Report link

Does this return the expected results? I've highlighted cells for illustration of the first result. "Shanghai" occurs 2 times in columns C to H where "Shanghai" is in the same row in column A.

=SUM(N(IF($A$1:$A$30=K1,$C$1:$H$30=K1)))

excel

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (0.5):
Posted by: user22566114