J
=SOMMEPROD((D11:D20=G5)*(E11:E20=G6))
=SOMMEPROD((((D11:D20-1)=G5)+((D11:D20+1)=G5)+(D11:D20=G5))*(E11:E20=G6))
ou
=SOMMEPROD(((D11:D20=(G5-1))+(D11:D20=(G5+1))+(D11:D20=G5))*(E11:E20=G6))
=SOMMEPROD((ABS(D11:D20-G5)<2)*(E11:E20=G6))
=SOMMEPROD((ABS(D11:D20-G5)<2)*(ABS(E11:E20-G6)<2)