Scolding or squirting the cat makes the cat thinks the problem is associated with you, not the counter, the kitty thinks it’s you don’t allow him to go there. Also tell everybody at home to get them off the counter, not only you.
You have to make him associate the counter as an unpleasant place. Some of @meatn3 propose might work.
My cat doesn’t like foil, and wouldn’t go near it. But it doesn’t bother my neighbour’s cat, as I put some around the plants outdoor that I didn’t want him to touch. So test every method, each cat is different.
Sticky tape on a big cardboard may work and put the board on a slanted angle, so if he jumps on the counter, the board will slide and falls on floor. I read about piling a few empty cans, the cat jumps and hit them, and they fell with rattling sound…and frightens the cat.
Or try to put citrus peel garlic, onion, etc on the counter, when you aren’t there. Rub some mint citrus peel on the counter surface. Sprinkled some strong spice like cinnamon…
Also try to understand why the cat wants to go to the counter. If his aim is just to get your attention or to “play” with him, then squirting him is useless, but renforce the behaviour. My cat when he was younger, went on the counter at night, sometimes to just to get his toy - the rubber seal (for mason jars) to play with. At one point, we had a litter box with cover, and he disliked using that, he prefers to use the kitchen sink instead. Once we changed the box with a no lid one, he stopped visiting the counter.